2 Replies Latest reply on Jul 19, 2011 5:21 PM by 764712

    can't login sysdba

      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.
      [drab@localhost ~]$ sqlplus / as sysdba
      SQL*Plus: Release - Production on Tue Jul 19 09:24:58 2011
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      ORA-01031: insufficient privileges
      [drab@localhost ~]$ lsnrctl start
      LSNRCTL for Linux: Version - 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 - 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
      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
          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 ...
          ...  database open ...
          • 2. Re: can't login sysdba
            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.