| weird problem about the listener [message #60469] |
Mon, 09 February 2004 21:55  |
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)
)
)
|
|
|
|
| Re: weird problem about the listener [message #60478 is a reply to message #60469] |
Tue, 10 February 2004 06:55  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Looks like a DNS problem. Check with your Network/Sysadmin if DNS is configured OK and if there are any intermittant problems. Once you add the local names resolution(/etc/hosts etc), you are able to connect fine.
-Thiru
|
|
|
|
| Re: weird problem about the listener [message #60492 is a reply to message #60478] |
Tue, 10 February 2004 18:46 |
cuihh6
Messages: 12
Registered: February 2004
|
Junior Member |
|
|
Re: weird problem about the listener
We didn't use DNS Service.
Please pay attention to : In my problem, just after the restart of the listener,i can connect to the DB, after about 30 seconds new connection to the DB failed and the "ORA-12545 error" appeared.
|
|
|
|
| Re: weird problem about the listener [message #60498 is a reply to message #60492] |
Wed, 11 February 2004 04:02 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You are asking me to pay attention ! thats nice way to get some help,dont you think !?
When you are able to connect at one point of time , and failed to connect after some time, it could very well be a DNS problem.
You said "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"
doesnt it indicate it 'could' be a problem with names resolution !?
Just remember to be courteous when asking for free help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
