can't login to oracle 11g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: can't login to oracle 11g

  1. #1
    Join Date
    May 2012
    Posts
    2

    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:

    Code:
    [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 11.2.0.1.0 Production on Fri May 25 22:55:11 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Enter user-name: system
    Enter password: 
    ERROR:
    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:
    Code:
    -bash-4.0$ echo $ORACLE_HOME
    /tank/oracle/112

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

    Code:
    -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
    Code:
    -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
    Location
    England
    Posts
    7,333
    that error implies the database isn't running - are you sure it is?

  3. #3
    Join Date
    May 2012
    Posts
    2

    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:

    Code:
    [openindiana:~] oracle% sqlplus system/secret
    SQL*Plus: Release 11.2.0.1.0 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 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> select instance_name from v$instance;
    
    INSTANCE_NAME
    ----------------
    jfora

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    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
    Posts
    3
    Hi,

    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