Re: oracle_home

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 05 Apr 2013 17:14:45 +0100
Message-ID: <515EF875.8000305_at_dunbar-it.co.uk>

On 05/04/13 16:24, Zelli, Brian wrote:
> Ok, got it to work once, then I logged off, logged back in and re-traced my steps.....
> ORACLE_BASE=/u01/oracle11g;exported it
> ORACLE_HOME=/u01/oracle11g/product/11.2.0/dbhome_1;exported it
> ORACLE_SID=orcleg;exported it

Why?

What's wrong with logging in as the appropraite (oracle) user and running :

. oraenv

Then typing in the SID when prompted. Alternatively:

. oraenv <<EOF
YOUR SID HERE
EOF Then try logging in to the database.

Setting only thye above variables doesn't clear out any 10g settings, and I suspect you have got the ORA_NLS* or similar stuff still set to what it was previoulsy.

Oraenv is supplied to make your life easy, I'm puzzled as to whay you are not using it.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 05 2013 - 18:14:45 CEST