| Help!! Can't connect local DB [message #109407] |
Thu, 24 February 2005 07:54  |
runinwind
Messages: 7
Registered: February 2005
|
Junior Member |
|
|
Hello all:
I just installed a 9i DB on local machine,but can't connect using develop tools,pls help me.
Ora Home1 = D6i (Developer 6i)
Ora Home2 = O9i (Oracle 9i 9204)
their tnsnames.ora is same,here is the content(lite is my localhost,support is another host that running o9i also):
O9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lite)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = o9i)
)
)
SUPPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = support)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Here is my question:
using o9i's sqlplus,i can connect to o9i and support,
using D6i's sqlplus,i only can connect to support,when connecting to o9i,sqlplus(or any other client tools such as form builder,form runtime) will crash!
Here is one segment of the content in sqlnet.log reporting the error:
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROT OCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\d6ip\BIN\PLUS80W.EXE)(HOST=LITE)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
Time: 24-FEB-2005 20:39:29
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
Thanks for any help!
|
|
|
|
|
|
| Re: Help!! Can't connect local DB [message #109409 is a reply to message #109408] |
Thu, 24 February 2005 08:15  |
runinwind
Messages: 7
Registered: February 2005
|
Junior Member |
|
|
thank you. i have checked d6i's tnsnames.ora,it registered my db,it should be ok.
and i have tried to replace the hostname(my localmachine name) with IP address,can't help.
For your more information,i tried to connect my db from the host support,same thing happened at that machine,its client tools crashed when connecting my db,but it can connect to its own db.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
