Listener.ora [message #55684] |
Fri, 07 February 2003 14:22 |
Carlos Olmeda
Messages: 22 Registered: January 2003
|
Junior Member |
|
|
Hello once again, Im sorry to be a bother, however zi still cannot connect to my databases that I created in oracle 7.3 I am posting my listener.ora & tnsnames.ora to see if there are any errors. also can I be provided with ta listener and tnsmaes script?. I have 4 databases on the same server PROD, TEST, DEV and ORACLE
Any assistance will be greatly appreciated.
Thank You.
Listener.ora:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= NTSERVER)
(PIPE= ORAPIPE)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = ntserver)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = ntserver)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = ntserver)
(PROTOCOL= TCP)
(Port= 1526)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
)
PASSWORDS_LISTENER = (oracle)
tnsnames.ora:
test.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = TEST)
)
)
prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = PROD)
)
)
dev.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = DEV)
)
)
oracle.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = ORACLE)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = TEST)
)
)
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = PROD)
)
)
DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.101.1)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = DEV)
)
)
)
|
|
|
Re: Listener.ora [message #55687 is a reply to message #55684] |
Sat, 08 February 2003 00:05 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
hello Carlos,
just try to do this way,
start all the databases , and then the corresponding Listener[[s]] and Connect by saying
connect system@prod
followed by the password of system ([b]manager[b] by
default)
sai
|
|
|