SQL server error connecting due to wrong parameters

Asked By Christopher B Wilkerson 0 points N/A Posted on - 08/06/2014

Hello,

I have this error when I want to connect to SQL server and I have checked everything, Internet connection is working just fine, the initialization parameters are OK and I don’t know how to proceed anymore. Can anyone help me please to fix this error ? What could be the problem ?

Thank you !

Error Connecting

An error was encountered performaing the requested operation:

ORA- 00257: archiver error. Connect internal only , until freed.

00257.00000 – “archiver error. Connect internal only , until freed”.

“Cause: The archiver process received an error while trying t archive a redo log. If the problem is nt resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.

“Action: Check archiver trace file for a detailed description

Of the problem. Also verify that the device specified in the initialization parameter

ARCMIVE_LOC_DEST is set up properly for archiving.

Vendor code 257

• Status: Open
• Question Views: 675
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Foster Cheryl 0 points N/A #180116

SQL server error connecting due to wrong parameters

Hello,

This all depends on your version of Oracle.

It depends on the version of the Oracle but in most cases you can go to the command prompt and

type: sqlplus /nolog

Then go to the SQL Prompt and type: conn / as sysdba

Archive log list and make sure you are archiving where you are;

Type in SQL prompt: show parameter arch.

About Foster Cheryl

Questions
0

Answers
101

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/19/2014
• Question Category: MySQL Server