Home » RDBMS Server » Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified [message #196731] Fri, 06 October 2006 21:54 Go to next message
nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam
Member
After my server (windown 2003) is shutdown, I login to database and meet a mesage: ORA-12154: TNS:could not resolve the connect identifier specified
My computer is server that We don't change any config in computer.
Ipconfig /all
   Host Name . . . . . . . . . . . . : ...
   Primary Dns Suffix  . . . . . . . : ...
   Node Type . . . . . . . . . . . . : ...
   IP Routing Enabled. . . . . . . . : ...
   WINS Proxy Enabled. . . . . . . . : ...
   DNS Suffix Search List. . . . . . : ...

Ethernet adapter Local Area Connection:

   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : ...
   Physical Address. . . . . . . . . : ...
   DHCP Enabled. . . . . . . . . . . : ...
   IP Address. . . . . . . . . . . . : ...
   Subnet Mask . . . . . . . . . . . : ...
   Default Gateway . . . . . . . . . : ...
   DNS Servers . . . . . . . . . . . : ...
                                       ...


startup database
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  163577856 bytes
Fixed Size                   787948 bytes
Variable Size             103807508 bytes
Database Buffers           58720256 bytes
Redo Buffers                 262144 bytes
ORA-00204: error in reading (block 3, # blocks 8) of controlfile
ORA-00202: controlfile:
'...'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

Please help me give solution for this problem.
Thanks,

NghiaNT

[Mod-edit: Anonymized]

[Updated on: Thu, 14 June 2007 23:04] by Moderator

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #196751 is a reply to message #196731] Sat, 07 October 2006 01:03 Go to previous messageGo to next message
pareshjavkar
Messages: 7
Registered: October 2006
Location: Mumbai
Junior Member
Dear Friend,

Your Control file has been corrupted. Is your controlfile multiplexed i.e. multiple copies of control file kept at different location.

If yes, shutdown the database, bring a non-corrupted copy of the controlfile to the corrupted location and rename it to the name of corrupted controlfile ('...'). startup, this will solve the problem.

Else, remove the entry of corrupted controlfile from initilization parameter file and start the database with the other copy/copies of controlfile.


[Mod-edit: Anonymized]

[Updated on: Thu, 14 June 2007 23:03] by Moderator

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #196753 is a reply to message #196731] Sat, 07 October 2006 01:06 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

if u don't have copy of control file then use "create controlfile reuse" cmd.

look for documentation for above syntax.
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #196783 is a reply to message #196753] Sat, 07 October 2006 05:30 Go to previous messageGo to next message
nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam
Member
Thanks for yours reply.
Now, I can open database. Because my database has 3 controls file. I was delete error control3.ctl, copy new control file and rename it is control3.ctl.
And then, Shutdown database and startup database.
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #196799 is a reply to message #196783] Sat, 07 October 2006 10:40 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Now plz. take ur consistent bkp. shutdown and bkp. startup
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #198050 is a reply to message #196783] Sat, 14 October 2006 02:46 Go to previous messageGo to next message
pareshjavkar
Messages: 7
Registered: October 2006
Location: Mumbai
Junior Member
No Message Body
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #198051 is a reply to message #196783] Sat, 14 October 2006 02:47 Go to previous message
pareshjavkar
Messages: 7
Registered: October 2006
Location: Mumbai
Junior Member

You are Welcome
Previous Topic: Internal error during export
Next Topic: Error Logging into Oracle Database
Goto Forum:
  


Current Time: Fri Dec 09 13:57:07 CST 2016

Total time taken to generate the page: 0.11051 seconds