can't login to oracle 11g

[bluethundr]

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 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:

-bash-4.0$ echo $ORACLE_HOME
/tank/oracle/112

And my oracle_sid is set to:

-bash-4.0$ echo $ORACLE_SID
ORA11GR2

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!

[davey23uk]

that error implies the database isn't running - are you sure it is?

[bluethundr]

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 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

[gandolf989]

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.

[maheop]

Hi,

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