Home » RDBMS Server » Server Administration » Cannot start listener (/tmp related) (AIX 6.1 64bit - Oracle 10gR2 (10.2.0.5.0))
Cannot start listener (/tmp related) [message #554026] Wed, 09 May 2012 22:44 Go to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

OS: AIX 6.1 64bit
DB: Oracle 10gR2 (10.2.0.5.0)

What we did is..
1. Install patch 6613550 (./rootpre.sh)
2. Install 10.2.0.1 for AIX 64-bit
3. Install 10.2.0.5 Patch Set
4. Create Database
5. Created/Setup LISTENER and TNSNAMES (test connection successful)

After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner

What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start)

The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)

BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:
$TEMP=/directory
$TMPDIR=/directory
$export TEMP TMPDIR

I was thinking if that we must make a temp directory for oracle and set it in the profile, or change the owner to root again and perform this:
$chown -R oracle:oinstall /tmp
$chmod -R 777 /tmp
Re: Cannot start listener (/tmp related) [message #554027 is a reply to message #554026] Wed, 09 May 2012 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
listener has no inherent involvement with /tmp

was root.sh successfully run as part of post installation tasks?
Re: Cannot start listener (/tmp related) [message #554030 is a reply to message #554027] Wed, 09 May 2012 23:09 Go to previous message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

Hello BlackSwan! We run the root.sh after installing 10.2.0.1 database, and after installing the 10.2.0.5 patch set..
Previous Topic: temp tablespace error ORA-1652
Next Topic: Oracle Export Import Utility Different Versions
Goto Forum:
  


Current Time: Thu Nov 15 17:07:33 CST 2018