Try
$ export ORACLE_SID=yourdbname
$ export ORACLE_HOME=/u1/oracle/product/10.2.0 (example)
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib (should be set)
As for changing ownership like I see earlier, not a good idea. You need
to patch and upgrade in the future, and changing ownership from oracle
is usually a bad idea. It can be done;
$ chown -R myusername $ORACLE_HOME (assuming the variable is set) Still
not a good idea.
-----Original Message-----
From: Sheikh Imtiaz
[mailto:oracledba-ezmlmshield-x8019215.[Email address protected]
Sent: Thursday, October 05, 2006 7:27 AM
To: LazyDBA Discussion
Subject: RE: Oracle not available while connecting to db through DB
If you running more then one database on the same machine then make sure
you
are setting the environment variable according to the SID.
Imtiaz
-----Original Message-----
From: Koil Doss (ZADCO ITTS)
[mailto:oracledba-ezmlmshield-x7281703.[Email address protected]
Sent: Thursday, October 05, 2006 5:05 AM
To: LazyDBA Discussion
Subject: RE: Oracle not available while connecting to db through DB
Hi,
If the DB is up and running, check your tnsnames.ora file and DBlinks
if you are using any.
Regards,
Koil Doss
Database Administrator
-----Original Message-----
From: RajeshKumar
[mailto:oracledba-ezmlmshield-x58802493.[Email address protected]
Sent: 05 October 2006 01:51 PM
To: LazyDBA Discussion
Subject: Oracle not available while connecting to db through DB
$sqlplus system/[Email Address Removed] ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Thanks & Regards,
Rajesh Kumar Mathur
-----Original Message-----
From: Sood Ankit (GE Money consultant)
[mailto:oracledba-ezmlmshield-x23281839.[Email address protected]
Sent: Thursday, October 05, 2006 3:09 PM
To: LazyDBA Discussion
Subject: change in ownership
Hi,
I have installed the Oracle software as unix user .Now I created the
Other unix user .I just want to know that is it possible to change the
owner of the Oracle software at the unix level.
Ankit Sood
*********************************
GE Money Japan,Tokyo
Phone : +81-42-330-8734
Mobile: +81-90-9842-9482
Email:ankit.[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
========================================================================
====================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
========================================================================
====
================================ This e-mail may contain confidential
and/or
privileged information. If you are not the intended recipient (or have
received this e-mail in error) please notify the sender immediately and
destroy this e-mail.
========================================================================
====
================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
The company reserves the right to amend statements made herein in the
event of a mistake. Unless expressly stated herein to the contrary, only
agreements in writing signed by an authorized officer of the Company may
be enforced against it.
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page