We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

ORA-01034: ORACLE not available

smurff
smurff asked
on
Medium Priority
1,790 Views
Last Modified: 2013-12-18
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
Comment
Watch Question

johnsoneSenior Oracle DBA
CERTIFIED EXPERT

Commented:
Try this:

ORACLE_SID=ARS
export ORACLE_SID

On a UNIX box, I believe the SID is case sensitive.

Author

Commented:
Thanks but that didnt work

Thanks anyway
johnsoneSenior Oracle DBA
CERTIFIED EXPERT

Commented:
I see you are logged in as root.  What happens if you connect as the software owner (probably oracle).
SujithData Architect
CERTIFIED EXPERT

Commented:
what is the output of
env | grep ORA

Author

Commented:
Guys I resolved it. I removed the ORACLE_HOME reference and it worked. I dont know why though.
CERTIFIED EXPERT
Commented:
Make sure that the ORACLE_HOME and ORACLE_SID properly match within the files /etc/oratab or /var/opt/oracle/oratab

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.