2 Replies Latest reply: Jul 19, 2011 12:21 PM by 764712 RSS

    can't login sysdba

    764712
      Hi,
      I have problem with my db to start, it was NOT set to start on reboot, so now I'm running script to set a correct path, but after that I can't login as sysdba to startup it, what is wrong in here, it's 10g XE on Fedora 14.
      I also can't lsnrctl start neither even being a root.
      Tx
      T
      [drab@localhost ~]$ sqlplus / as sysdba
      SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 19 09:24:58 2011
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      ERROR:
      ORA-01031: insufficient privileges
      
      [drab@localhost ~]$ lsnrctl start
      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-JUL-2011 09:57:34
      Copyright (c) 1991, 2005, Oracle.  All rights reserved.
      Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...
      
      TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
      Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
      Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      TNS-12555: TNS:permission denied
       TNS-12560: TNS:protocol adapter error
        TNS-00525: Insufficient privilege for operation
         Linux Error: 1: Operation not permitted
      
      Listener failed to start. See the error message(s) above...
      Edited by: trento on Jul 19, 2011 9:57 AM
        • 1. Re: can't login sysdba
          clcarter
          can't lsnrctl start neither even being a root
          You don't want to do that. Set up the environment variables and start the listener and database as the oracle (or the user that owns the oracle software) user i.e.
          # ... oraenv.sh ...
          # su oracle -c "lsnrctl start"
          # su oracle -c "sqlplus /nolog"
          ... connect /as sysdba;
          ... connected to idle instance ...
          startup;
          ...  database open ...
          exit
          • 2. Re: can't login sysdba
            764712
            Thanks, carter

            Yes after su - oracle everything is working.
            I just noticed that after install I got a new user Oracle, thought that root will beat everybody.

            T