| Fatal NI connect error 12545, connecting to: [message #208449] |
Sun, 10 December 2006 23:15  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
