can not start listner and database please help

[smitanav]

hi all ,

i am not able to start database and listner as well , please see below and suggest me what to do ?

SQL> startup
ORA-01031: insufficient privileges
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-07217: sltln: environment variable cannot be evaluated.
SQL>
SQL> exit
Disconnected
$ lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-SEP-2004 01:57:21

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /export/home/oracle/app/oracle/product/9.1.7/bin/tnslsnr: please wait..

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /export/home/oracle/app/oracle/product/9.1.7/network/aa
Log messages written to /export/home/oracle/app/oracle/product/9.1.7/network/log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=utslab)(PORT=1521)
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNSrotocol adapter error
TNS-00515: Connect failed because target host or object does not exist


Listener failed to start. See the error message(s) above...

thanks and regards
Naveen

 

[hoinz]

check your environment variables,
at least ORACLE_HOME and ORACLE_SID
hth

 

[smitanav]

Thanks HTH ,

now i can start listner but getting some error as below ,database is also UP now

here it is

"STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 18-SEP-2004 04:30:03
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /export/home/oracle/app/oracle/product/9.1.7/network/a
Listener Log File /export/home/oracle/app/oracle/product/9.1.7/network/g
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.227.22)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cwbes" has 1 instance(s).
Instance "cwbes", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully"

regards

 

[hoinz]

Hi,

I can't see an error in your post ...
(except for 'status UNKNOWN', but this should be a minor problem.)

btw, 'hth' is not my name, but a shorthand for 'hope this helps'
and btw, 'btw' is not my name either, but a shorthand for 'by the way'
;-)

regards

 

[smitanav]

Hi HOINZ ,

sorry for the mistake ! thanks for your support


regards