| weird problem about the listener [message #67208] |
Mon, 09 February 2004 14:15 |
cuihh6
Messages: 12
Registered: February 2004
|
Junior Member |
|
|
Through my several attempts, i can conclude my problem:
Oracle 8.1.7.4 on AIX 4.3.3
Suppose the hostname of the database server is "H85". I also has another Aix box and a PC , both of them was used as oracle client.
I start the listener of the database server like this:
H85#lsnrctl start
And at this time the Services Summary of the listener 's status shows "test has 1 service handler(s)"(can be viewed through "lsnrctl status").
Both the PC and the Aix box can connect to the database successfully
But 30 seconds after the listener start, while the Services Summary of the listener 's status becomes :
test has 1 service handler(s)
test has 3 service handler(s)
At this time i must add the hostname of the database to the /etc/hosts of the Aix box and to the /winnt/system32/drivers/etc/hosts of the PC , then the Aix box and the PC can connect to the database.
the content of the etc/hosts and /winnt/system32/drivers/etc/hosts is:
10.9.221.55 H85
Otherwise,If i did not add the hostname of the database into the two files , the connection would failed:
ORA-12545:connect failed because target host or object does not exist.
Very very Strange.........
Here is the content of the listener.ora on H85:
- LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.221.55)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
#(SID_DESC =
# (GLOBAL_DBNAME = shyz)
# (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
# (SID_NAME = n1_flcp)
#)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(SID_NAME = test)
)
)
-
here is the content of the tnsnames.ora file on oracle client:
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.221.55)(PORT = 1521))
(CONNECT_DATA =
(sid = test)
)
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
