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
Printable View
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
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
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
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
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