Oracle 9i R2 Install and listener Problem 4

[Michael42]

Hello,

I am attempting to install Oracle 9i R2 on a Solaris 8 system.

Oracle 9i R2 was previously installed and worked fine on this system. I had to uninstall and reinstall to create "coookie-cutter" Oracle install docs.

My problem is in the OEM part of the installation (after creation of the database). I enter the user name sys, password, [db1] already selected and sysdba as user type. This part works.
The moment I select db1 I get the message: ORA-12541 TNS=no listerner

I happen to do the install in sync on another Solaris 8 system and it gets past this no problem.

I manually checked for the tnsnames.ora and it seems to be fine. I cannot start it manually using lsnrctl start. I get the message:
Error listening on: (DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
TNS1254: TNS no listener
TNS-12560: TNS: protocol adpater error

What can you recommend?

Thanks,

Michael42

 

[Michael42]

>> I manually checked for the tnsnames.ora ...
I also checked the listener.ora and it looks fine too.

 

[sybaseguru]

Michael,

Send the output from $ORACLE_HOME/network/admin/listener.ora. Also do

lsnrctl status

and send the output as well please

 

[Michael42]

Here you go - thanks again for your help!

lsnrctl status

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 02-SEP-2003 15:25:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=svfs2)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused[/color


svfs2% cat listener.ora
# LISTENER.ORA Network Configuration File: /usr2/oracle/OraHome1/network/administener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = svfs2)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr2/oracle/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db1)
(ORACLE_HOME = /usr2/oracle/OraHome1)
(SID_NAME = db1)
)
)

 

[sybaseguru]

OK,

What happens when you do lsnrctl start &.

And I notice solaris error messages
Solaris Error: 2: No such file or directory
Solaris Error: 146: Connection refused[/color
Are you starting listener as user oracle? do ls -l on listener.ora file and also $ORACLE_HOME/bin/lsnrctl and send the output

 

[Michael42]

>> What happens when you do lsnrctl start &.
svfs2% lsnrctl start &
[1] 610
svfs2%
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 03-SEP-2003 09:08:09

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

Starting /usr2/oracle/OraHome1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /usr2/oracle/OraHome1/network/admin/listener.ora
Log messages written to /usr2/oracle/OraHome1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory

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


>> Are you starting listener as user oracle?
Yes!

>> do ls -l on listener.ora file
svfs2% ls -l listener.ora
-rw-rw-r-- 1 oracle dba 653 Sep 2 13:42 listener.ora

>> ls -l $ORACLE_HOME/bin/lsnrctl and send the output
svfs2% ls -l $ORACLE_HOME/bin/lsnrctl
-rwxr-x--x 1 oracle dba 2818232 Sep 2 11:34 /usr2/oracle/OraHome1/bin/lsnrctl


Looking forward to your suggestions.


Thanks,

Michael42

 

[sem]

Does /usr2/oracle/OraHome1/network/log directory exist? How about listener.log file? Can Oracle write to it?

Regards, Dima

 

[Michael42]

sem,

>> Does /usr2/oracle/OraHome1/network/log directory exist?
yes

>> How about listener.log file?
yes

>> Can Oracle write to it?
yes



Thanks,

Michael42

 

[Michael42]

I Found It - Wooohoo!

All your responses prompted me to identifiy it.

The permissions on the directory /var/tmp where not correct. The permissions on /var/tmp/oracle where ok but this was a show stopper not having the above directory correct.

Thanks very much for all your help and prompt feedback!

-Michael-

Thanks,

Michael42