Solved

Oracle 10g sqlplus login problems

Posted on 2007-04-07
1
719 Views
Last Modified: 2013-12-18
I am running a server which I am connected to remotely.  The server OS is Red Hat Linux Enterprise 5 and the software giving me the problems is Oracle 10g version 10.2.0

I was originally getting this error when trying to enter sqlplus:

ERROR:
ORA-12162: TNS:net service name is incorrectly specified

However, I fixed that by running this command:
     export ORACLE_SID="system"

and now I get these problems when I try to sign into sqlplus:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

I have tried restarting the server and this has not corrected any problems.  Does anyone have any ideas?
0
Comment
Question by:spitfire0010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
Blue5Wing earned 50 total points
ID: 18871693
1. Check if your Oracle database is started.

2. Check the ORACLE_HOME environment variable if it matches the ORACLE_HOME used to start the database, as it is defined in /var/opt/oracle/oratab. In oratab you will find entries like this:

DEMO:/u01/app/oracle/product/10g:Y

In this case /u01/app/oracle/product/10g is ORACLE_HOME, DEMO is the SID, Y means it is started automatically at system boot.
You also need to set ORACLE_BASE.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
date show only hh:mm 2 50
mask value when navigating 5 23
Let's Encrypt - Auto Renew Failure via Cron Job 1 65
How to swap or extend CentOS partition 11 51
In my business, I use the LTS (Long Term Support) versions of Linux. My workstations do real work, and so I rarely have the patience to deal with silly problems caused by an upgraded kernel that had experimental software on it to begin with from a r…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question