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!

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

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

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.

Hi,

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