Home » RDBMS Server » Server Utilities » oracle environment setting (oracle 10.2.0.5 solaris 64 bit)
oracle environment setting [message #557616] Thu, 14 June 2012 05:06 Go to next message
guddu_12
Messages: 219
Registered: April 2012
Location: UK
Senior Member
Hello gurus,

In my unix box there is a oracle 10g installed, now for the new requirment on the sme box oracle 11gr2 has been installed. i have a same table in both the database , when i run the sql loader in loads into 10g database rather that 11g.

could you please help me to provide the setting so that it would load onto the correct data base. user is also same in both the database.

Please help

Re: oracle environment setting [message #557617 is a reply to message #557616] Thu, 14 June 2012 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just give the correct tnsnames.ora entry on connection string or set the correct ORACLE_SID variable to point to the correct database.

Regards
Michel
Re: oracle environment setting [message #558154 is a reply to message #557616] Tue, 19 June 2012 15:48 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
This will set your oracle environment, but make sure an entry for your 11g database
exists in the /etc/oratab file (or /var/opt/oracle/oratab for Solaris).

Add it at the top of your script:
ORAENV_ASK=NO
. /usr/local/bin/oraenv ORCL11  #<== Here you put the ORACLE_SID of the 11g database
#
# Environment is set, so continue with your commands here....

[Updated on: Tue, 19 June 2012 23:22] by Moderator

Report message to a moderator

Previous Topic: Skip Last Line in External table
Next Topic: What could be the fastest way to unload the data from oracle to text file.
Goto Forum:
  


Current Time: Thu Sep 24 03:58:59 CDT 2020