smurff
asked on
ORA-01034: ORACLE not available
Hi All,
I have installed Oracle on my Solaris box. I can connect using sqlplus system@sid_name but when I use sqlplus then press enter and then enter the details I get the above error. I am trying to install something that is giving me the above error so although I can connect specifying the system@sid_name, I really need for it to work with just sqlplus then entering the details.
Screen output:
swse450:/# id
uid=0(root) gid=0(root)
swse450:/# set | grep ORA
ORACLE_BASE=/u01/app/oracl e
ORACLE_HOME=/u01/app/oracl e/10.2.0
ORACLE_SID=ars
ORA_NLS10=/u01/app/oracle/ 10.2.0/nls /data
swse450:/# echo $PATH
/usr/sbin:/usr/bin:/usr/lo cal/bin:/u 01/app/ora cle/10.2.0 /bin:/u01/ app/oracle /10.2.0/cl ient/bin:/ usr/local/ bin:/usr/b in:/bin:/u sr/sbin:/e tc:/usr/cc s/bin:/usr /openwin/b in:/export /home/orac le:/usr/lo cal/sudo/b in:.
swse450:/# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 10 12:49:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
swse450:/# sqlplus@ars
bash: sqlplus@ars: command not found
swse450:/# sqlplus system@ars
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 10 12:49:28 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
---------
ARS
SQL>
Thank you and kind regards
Danny
I have installed Oracle on my Solaris box. I can connect using sqlplus system@sid_name but when I use sqlplus then press enter and then enter the details I get the above error. I am trying to install something that is giving me the above error so although I can connect specifying the system@sid_name, I really need for it to work with just sqlplus then entering the details.
Screen output:
swse450:/# id
uid=0(root) gid=0(root)
swse450:/# set | grep ORA
ORACLE_BASE=/u01/app/oracl
ORACLE_HOME=/u01/app/oracl
ORACLE_SID=ars
ORA_NLS10=/u01/app/oracle/
swse450:/# echo $PATH
/usr/sbin:/usr/bin:/usr/lo
swse450:/# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 10 12:49:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
swse450:/# sqlplus@ars
bash: sqlplus@ars: command not found
swse450:/# sqlplus system@ars
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 10 12:49:28 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
---------
ARS
SQL>
Thank you and kind regards
Danny
ASKER
Thanks but that didnt work
Thanks anyway
Thanks anyway
I see you are logged in as root. What happens if you connect as the software owner (probably oracle).
what is the output of
env | grep ORA
env | grep ORA
ASKER
Guys I resolved it. I removed the ORACLE_HOME reference and it worked. I dont know why though.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ORACLE_SID=ARS
export ORACLE_SID
On a UNIX box, I believe the SID is case sensitive.