listner not starting

[Former Member]

hi all

i chked wid lsnrctl status

lsnrctl start but getting error........ no listner..

i chked wid tnsping <host name> .... also tnsping < ip add> got error .host not reacheble ...

plz tell me the solution frm starting

REgards,

jiten

[Former Member · Accepted solution]

Hello Jiten,

check gor your listener file(listener.ora),some entries might be mssing

in that file SID and hostname file must be maintained

Also check your tnsnames.ora and sqlnet.ora files

correct them,your listener must work fine

Also if you have any issues please post the files here

and did u try starting ur database from OS level

Try doing that first as follows:

a. Start SQLPLUS:sqlplus u201C/as sysdbau201C

b. Start up the database to mount state:

SQL> startup mount

c. SQL> alter database open

If it is successful then try listener again

Rohit

[Former Member · Accepted solution]

i m unable to start sqlplus on hp-ux

also wher to find .ora files ? i didnt find in oracle dir

[Former Member · Accepted solution]

hello Jiten,

You can find the *.ora files in <oracle_home>/network/admin folder and then modify the files according to you hostname and port no.

And try to start the listner again.

And you can find the log of listner in the log directory which can be found in <oracle_home>/network/log.

Regards,

Ramkrishna

[Former Member · Accepted solution]

wat abt sqlplus?????/

[Former Member · Accepted solution]

r u sure abt oracle_home?? i didnt find oracle_home ...........

can u write commands perhaps i m using wrong commands

[Former Member · Accepted solution]

like go in /oracle/<SID>/102_64/network/admin

or may be /oracle/<SID>/902_64/network admin

so use the following command

like

CD /oracle/<SID>/102_64/network/admin

ls -ltr and u will get the required files

[Former Member · Accepted solution]

ya i chked files in both 102_ and 920_ location

sqlnet.ora,tnsnames.ora,listener.ora all hav difff permisssion n no 1 hav 777 permission.

nw tell wat to chk there........

Edited by: jiten singh on Feb 23, 2009 8:25 AM

Edited by: jiten singh on Feb 23, 2009 8:26 AM

[Former Member · Accepted solution]

hello

Login to OS and opened the command terminal

do this:

su - orasid

$ sqlplus \ as sysdba

you will connect

Rohit

[Former Member · Accepted solution]

dats fine but tell me wat shud b cheked in listener.ora n listener.ora

[Former Member · Accepted solution]

just post the files here

Rohit

[JPReyes · Accepted solution]

@jiten singh

Please stop using text message language

• Read the "rules of engagement"

Regards

Juan

[Former Member · Accepted solution]

please tell me what i have to check there in those file?

[JPReyes · Accepted solution]

You need to check that the port is correct, also the SID, the host, ORACLE_HOME, etc.

Regards

Juan

[Former Member · Accepted solution]

Hello Jiten,

Please check the paramters as said by juan as well as once u changed it check the following commands on OS level.

lsnrctl status

and if listner is not started the please start it by following command.

lsnrctl start

As well as can you please let us know whther the database was upgarded from oracle 9i to 10g?

Regards,

Ramkrishna

[Former Member · Accepted solution]

yes i checked but nothing is missing and port are same only sid used in one file is in capital letters and small in other.

oracle not upgraded.

regards,

jiten

[Former Member · Accepted solution]

hello,

Can you paste the listner.ora and tnsnames.ora files as well as output of lsnrctl status command here.

As well as the log file of it which can be found in /oracle/<SID>/102_64/network/log.

Regards,

Ramkrishna

[Former Member · Accepted solution]

Hello Jiten,

can you post these files on SDN

Rohit

[Former Member · Accepted solution]

thanks .. resolved by restore backup.......

[Former Member]

this is answered as i resolved it .

Thanks to all .