| unable to connect sqlplus [message #55322] |
Fri, 17 January 2003 08:23  |
rv
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
I have installed new oracle 8.
My sqlnet.ora is
------------------------------------
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
----------------------------------------------------
I am not able to connect if i give hoststring as localname specified.
I have to databases at the same ip address. Specifing the localname at hoststing give unable to resolve tns service name.
Giving hostname as hoststring gives no listener error.
-----------------------
tnsnames.ora
DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1522))
)
(CONNECT_DATA =
(SID = dev01)
)
)
TST01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1522))
)
(CONNECT_DATA =
(SID = tst01)
)
)
------------------------------------------
listner.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1522))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(PROGRAM = extproc)
)
-------------------------------
Please help
Thanks
Regards
|
|
|
|
| Re: unable to connect sqlplus [message #55323 is a reply to message #55322] |
Fri, 17 January 2003 09:16  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
comment the following lines in sqlnet.ora
reload and restart the listener.
Make sure u have started the database.
if database and client are in same machine...you dont need a connect string at all..
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
