OraFAQ Forum: Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified

Home » RDBMS Server » Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve the connect identifier specified [message #196731]

Fri, 06 October 2006 21:54

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

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

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.

Report message to a moderator

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

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.

Report message to a moderator