joehodge
asked on
setting up a db and tnsnameslisterner does not appear/work
Hi,
I have tried to install Toad on a windows 2003 server with a 9.2 oracle database.
I set up the database but when I try and connect to sqlplus/toad I get ora-12154: TNS: could not resolve service name....
The only difference I can find with this setup is that when I go to deveice manager - services there is no Ora92TNSnameslistener in the list. There has also been no TNS entry in Oracle\ora92\network\admin \.
I've manually put:
PLAYP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gbsflatest)(PORT = 1521))
(CONNECT_DATA = (SID = PLAYP1))
)
but still no joy.
When I try:
c:Lsnrctl status
I get lsnrctl for 32-bit windows.......
..........
starting tnslsnr: please wait..
Failed to open service <OracleOraHome92TNSListene r>, error 1060
STATUS of the Listener..........
..........
The listener supports no services
any ideas what Im doing wrong?
I have tried to install Toad on a windows 2003 server with a 9.2 oracle database.
I set up the database but when I try and connect to sqlplus/toad I get ora-12154: TNS: could not resolve service name....
The only difference I can find with this setup is that when I go to deveice manager - services there is no Ora92TNSnameslistener in the list. There has also been no TNS entry in Oracle\ora92\network\admin
I've manually put:
PLAYP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gbsflatest)(PORT = 1521))
(CONNECT_DATA = (SID = PLAYP1))
)
but still no joy.
When I try:
c:Lsnrctl status
I get lsnrctl for 32-bit windows.......
..........
starting tnslsnr: please wait..
Failed to open service <OracleOraHome92TNSListene
STATUS of the Listener..........
..........
The listener supports no services
any ideas what Im doing wrong?
ASKER
Hi,
I have now set the oracle_sid=playp1 and I can enter sqplus via the dos prompt.
I still get an tnsnames error if I try and access the database throgh TOAD or sqlplus (via Programs - Application Development - SQPLUS)
?? Im confused??
I have now set the oracle_sid=playp1 and I can enter sqplus via the dos prompt.
I still get an tnsnames error if I try and access the database throgh TOAD or sqlplus (via Programs - Application Development - SQPLUS)
?? Im confused??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
thats got it working. I put
NAMES.DEFAULT_DOMAIN = WORLD
in my sqlnet.ora
and then
PLAYP1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = GBSFTEST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLAYP1)
)
and it worked.
thanks
thats got it working. I put
NAMES.DEFAULT_DOMAIN = WORLD
in my sqlnet.ora
and then
PLAYP1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = GBSFTEST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLAYP1)
)
and it worked.
thanks
ASKER
however, when I try c:\ Lsnrctl status I get :
Service OracleOraHome92TNSListener
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error