Home » RDBMS Server » Networking and Gateways » Fatal NI connect error 12545, connecting to:
Fatal NI connect error 12545, connecting to: [message #208449] Sun, 10 December 2006 23:15 Go to next message
sureshkhadloya@yahoo.com
Messages: 4
Registered: September 2006
Junior Member
All,

I have installed oracle 9.2.0.1.0 client on solaris 9. I have configured tnsnames.ora

REFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.111.11.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = g08)
)
)


When i do tns ping, its shows status as "ok"

----------------------------------------------------------------
$ tnsping REFDB
TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 08-DEC-2006 11:58:24
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/opt/oracle/u01/app/products/9.2.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.111.11.11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = g08)))
OK (0 msec)
----------------------------------------------------------------

Now, when i use sqlplus to connect to DB, i get

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

and following entry in sqlnet.log

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/oracle/u01/app/products/9.2.0/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION
=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=dev09)(USER=oracle))))

VERSION INFORMATION:
TNS for Solaris: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 9.2.0.1.0 - Production
Time: 11-DEC-2006 03:57:36
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0

Can anyone please let me know, what can be potential problems?



Regards
SKK
Re: Fatal NI connect error 12545, connecting to: [message #208452 is a reply to message #208449] Sun, 10 December 2006 23:32 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist


sql>startup
bcoz ur database is not open.

TNS-12545: Connect failed because target host or object does not exist

Post ur listener.ora file.
and check in listener.ora file

Host string specify in "IP ADDRESS" instead of "Name".
and if you specify "IP ADDRESS" then it match ur "tnsnames.ora" file.

hope this helps
Taj
Re: Fatal NI connect error 12545, connecting to: [message #208553 is a reply to message #208452] Mon, 11 December 2006 05:34 Go to previous messageGo to next message
sureshkhadloya@yahoo.com
Messages: 4
Registered: September 2006
Junior Member
Thanks Taj,

Problem was the DB Admin had specified wrong SID, specifying the correct SID solved the issue.

Rgds,
SKK
Re: Fatal NI connect error 12545, connecting to: [message #208563 is a reply to message #208553] Mon, 11 December 2006 05:57 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

it is fine you are solve ur problem.
but when you get "oracle not available" most possibly clause is ur Oracle Database services is down.

regards
Taj
Previous Topic: oracle spawns new listener (Oracle 10GR2)
Next Topic: ORA-12170 Timeout issue
Goto Forum:
  


Current Time: Sun Dec 04 08:41:18 CST 2016

Total time taken to generate the page: 0.08154 seconds