• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1746
  • Last Modified:

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/oracle
ORACLE_HOME=/u01/app/oracle/10.2.0
ORACLE_SID=ars
ORA_NLS10=/u01/app/oracle/10.2.0/nls/data
swse450:/# echo $PATH
/usr/sbin:/usr/bin:/usr/local/bin:/u01/app/oracle/10.2.0/bin:/u01/app/oracle/10.2.0/client/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/etc:/usr/ccs/bin:/usr/openwin/bin:/export/home/oracle:/usr/local/sudo/bin:.
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
0
smurff
Asked:
smurff
1 Solution
 
johnsoneSenior Oracle DBACommented:
Try this:

ORACLE_SID=ARS
export ORACLE_SID

On a UNIX box, I believe the SID is case sensitive.
0
 
smurffAuthor Commented:
Thanks but that didnt work

Thanks anyway
0
 
johnsoneSenior Oracle DBACommented:
I see you are logged in as root.  What happens if you connect as the software owner (probably oracle).
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
SujithData ArchitectCommented:
what is the output of
env | grep ORA
0
 
smurffAuthor Commented:
Guys I resolved it. I removed the ORACLE_HOME reference and it worked. I dont know why though.
0
 
ravindran_eeeCommented:
Make sure that the ORACLE_HOME and ORACLE_SID properly match within the files /etc/oratab or /var/opt/oracle/oratab
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now