Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    26

    Unanswered: Cannot start listener (/tmp related)

    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: TNSermission denied
    TNS-12560: TNSrotocol 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 oracleinstall /tmp
    $chmod -R 777 /tmp

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results from follow OS commands

    id
    ls -ltr $ORACLE_HOME/dbs
    env | sort

    COPY the commands & results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2012
    Posts
    26
    id
    uid=206(oracle) gid=202(oinstall) groups=204(dba)

    ls -ltr $ORACLE_HOME/dbs
    total 96
    -rwxrwxr-x 1 oracle oinstall 8385 Sep 11 1998 init.ora
    -rwxrwxr-x 1 oracle oinstall 12920 May 03 2001 initdw.ora
    -rwxrwxr-x 1 oracle oinstall 1544 May 09 17:42 hc_test.dat
    -rwxrwxr-x 1 oracle oinstall 24 May 09 18:11 lkFPAC
    -rwxrwxr-x 1 oracle oinstall 2560 May 09 19:48 spfilefpac.ora
    -rw-r----- 1 oracle oinstall 1536 May 09 11:07 orapwfpac
    -rwxrwxr-x 1 oracle oinstall 1544 May 09 11:36 hc_fpac.dat

    env | sort

    AUTHSTATE=files
    A__z=! LOGNAME
    CLCMD_PASSTHRU=1
    DISPLAY=192.168.1.2:0.0
    HOME=/home/oracle
    LANG=en_US
    LC_FASTTMSG=true
    LOCPATH=/usr/lib/nls/loc
    LOGIN=oracle
    LOGNAME=oracle
    MAIL=/usr/spool/mail/oracle
    MAILMSG=[YOU HAVE NEW MAIL]
    NLSPATH=/usr/lib/nls/msg/%:/%N:/usr/lib/nls/msg/%L/:N.cat
    ODMDIR=/etc/objrepos
    ORACLE_HOME=/home/oracle
    ORACLE_SID=fpac
    PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin
    PWD=/home/oracle
    SHELL=/usr/bin/ksh
    TERM=dtterm
    TZ=TAIST-8
    USER=oracle
    =/usr/bin/env

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by Rektanocrit View Post
    id
    uid=206(oracle) gid=202(oinstall) groups=204(dba)

    ls -ltr $ORACLE_HOME/dbs
    total 96
    -rwxrwxr-x 1 oracle oinstall 8385 Sep 11 1998 init.ora
    -rwxrwxr-x 1 oracle oinstall 12920 May 03 2001 initdw.ora
    -rwxrwxr-x 1 oracle oinstall 1544 May 09 17:42 hc_test.dat
    -rwxrwxr-x 1 oracle oinstall 24 May 09 18:11 lkFPAC
    -rwxrwxr-x 1 oracle oinstall 2560 May 09 19:48 spfilefpac.ora
    an anomaly caught my eye!
    why "lkFPAC"?

    "FPAC" is different than "fpac"

    with *NIX ORACLE_SID is CaseSensitive
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •