-
listener problem on aix
hello friends
i have oracle 8i on aix and database is working properly
but listener is not working
when i say
start listener
the process gets hang my
listener.ora is ok
can any body help me
any type of help will be well come
bhushan
-
Can you post you listener.ora and sqlnet.ora
Also are there any errors reported in $ORACLE_HOME/network/log/listener.log
regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
LISTENER
HELLO
I AM SENDING MY FILES
/***************
listener.ora
*^***************/
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aix)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = hurtado.hurtado.com)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(SID_NAME = hurtado)
)
)
/***********************
sqlnet.ora
*************************/
SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf
regards
bhushan
-
Are there any errors reported in $ORACLE_HOME/network/log/listener.log
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
my error is the listener.log
hello
i am sending .log file
Trace level is currently 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aix)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
can u explan me
what is the entry in the sqlnet.ora file
regards
bhushan
-
Bhushan,
SQLNET.CRYPTO_SEED
Specifies the characters used when generating cryptographic keys. The more random the characters are, the stronger the keys are. This is required whenever encryption or checksumming is turned on
***********************************************************
Check the listener process
ps -ef|grep tns
This will give the list if the listener is running.
If it is running ,shut it down and restart.
Sometimes it happens even lsnrctl status command will hang.
You have to check the CPU consumption.
If it is too much sometimes listener hangs .
During that situation ,lsnrctl stop also willnot help.
So give : kill - 9 listenerprocessid
Then restart the listener.
If that is not the situation,Check with the sysadmin for the portno . Jus' try to get a different portno which is not conflicting.
Edit listener.ora accordingly and restart ..
Hope this helps
K.Chithra
Oracle DBA
-
LISTENER problem
it is still having the same problem
i did tryed the gerp and it shows the process for listener
but for connection from win2000 i have the same
ora-27101 prblem
i am putting my ps -ef | grep tns output
************************************************
@aix /oracle$ ps -ef | grep tns
oracle 11444 9814 0 19:43:48 pts/1 0:00 grep tns
oracle 12396 1 0 19:56:55 pts/0 0:00 /oracle/app/oracle/product/8.1.7/bin/tnslsnr listener -inherit
bhushan
Last edited by BHUSHAN; 03-07-2003 at 05:29 AM.
-
hello
friends
with the help of all u i am able to solev
this problem
what i did is that
just change the listener.ora
in place of hostname i put ip address
my listener was starting and stoping normal
this sorted out my problem
special thanks to
k. chitra and mr. amar
bhushan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|