DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    May 2012

    Thumbs down can't login to oracle 11g

    hello DBA forums

    I have a new 11g installation on solaris 11 (openindiana) that seemed to go well. But when I go to log into the database I see this message:

    [root@openindiana:/export/home/bluethundr] #su - oracle
    OpenIndiana (powered by illumos)    SunOS 5.11    oi_151a3    March 2012
    -bash-4.0$ sqlplus
    SQL*Plus: Release Production on Fri May 25 22:55:11 2012
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    Enter user-name: system
    Enter password: 
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Solaris-AMD64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0
    My oracle home is set to:
    -bash-4.0$ echo $ORACLE_HOME

    And my oracle_sid is set to:
    -bash-4.0$ echo $ORACLE_SID
    I did my entire oracle install on a zfs pool for enhanced performance.

    -bash-4.0$ ls -l /tank/oracle/
    total 23
    drwxr-xr-x  74 oracle   oinstall      77 May 24 22:03 112
    drwxr-x---   3 oracle   oinstall       3 May 24 21:50 admin
    drwxr-xr-x   5 oracle   oinstall       5 May 24 21:56 cfgtoollogs
    drwxr-xr-x   3 oracle   oinstall       3 May 24 22:03 checkpoints
    drwxrwxr-x  11 oracle   oinstall      11 May 24 21:50 diag
    drwxr-x---   4 oracle   oinstall       4 May 24 21:51 flash_recovery_area
    drwxr-x---   3 oracle   oinstall       3 May 24 21:50 oradata
    -bash-4.0$ ls -l /tank/oraInventory/
    total 20
    drwxrwx---   2 oracle   oinstall       5 May 24 21:50 ContentsXML
    -rw-rw----   1 oracle   oinstall      38 May 24 21:50 install.platform
    drwxrwx---   2 oracle   oinstall       5 May 24 21:44 logs
    -rw-rw----   1 oracle   oinstall      53 May 24 21:50 oraInst.loc
    -rw-rw----   1 oracle   oinstall     287 May 24 21:44 oraInstaller.properties
    -rwxrwx---   1 oracle   oinstall    1662 May 24 21:50 orainstRoot.sh
    drwxrwx---   2 oracle   oinstall       3 May 24 21:44 oui
    I'm sure it's a matter of tweaking some environment variables but please help me learn what I need to do to log into my new database.

    Curiously I can log into the web interface but not from the command line.

    thank you!

  2. #2
    Join Date
    Sep 2002
    that error implies the database isn't running - are you sure it is?

  3. #3
    Join Date
    May 2012

    Thumbs up got it working

    hey there,

    thanks for your reply. I was able to login and start the database. I can show the instance name at this point, but I haven't done anything else with this just yet. Looking forward to learning more about oracle with this box:

    [openindiana:~] oracle% sqlplus system/secret
    SQL*Plus: Release Production on Sat May 26 18:44:02 2012
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 11g Enterprise Edition Release - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    SQL> select instance_name from v$instance;

  4. #4
    Join Date
    Nov 2000
    Pittsburgh, PA
    Try "select status from v$instance;" instead.
    You can also try "ps -ef | grep dbw0"
    or "env | egrep "ORACLE|TNS_ADMIN|PATH"
    to make sure that you environment is set.
    this space intentionally left blank

  5. #5
    Join Date
    May 2012

    I think it is in mount state. You have to open it.
    SQL> alter database open;

Tags for this Thread

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.