listener problem on aix

[BHUSHAN]

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

[jovery]

Can you post you listener.ora and sqlnet.ora

Also are there any errors reported in $ORACLE_HOME/network/log/listener.log

regards

[BHUSHAN]

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

[jovery]

Are there any errors reported in $ORACLE_HOME/network/log/listener.log

Regards

[BHUSHAN]

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

[k.chithra]

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

[BHUSHAN]

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

[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