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!