Shell Programming and Scripting

Hi,

For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus username/password ie,without appending the instance name?.If yes,what all are the configurations i have to make before doing this?Your help is appreciated.

With Regards
Dileep

If you define ORACLE_SID, sqlplus user/password will connect you to $ORACLE_SID,
$ORACLE_HOME has to point to a locally mounted directory. There is another variable, TWO_TASK which needs to be set when the instance is on a remote box. It needs to be set to the full name of the remote instance as defined in tnsnames.ora.

Code:

sample tnsnames.ora --
VCSPROD.corp=
  (DESCRIPTION =
        (ADDRESS =
          (COMMUNITY = TCP.corp)
          (PROTOCOL = TCP)
          (Host = somename)
          (Port = 1521)
        )
      (CONNECT_DATA =
        (SID = PROD)
           (GLOBAL_NAME = VCSPROD.corp)
      )

Find SID above. SID=PROD that value -- ORACLE_SID=PROD
find GLOBAL_NAME GLOBAL_NAME=VCSPROD.corp. VCSPROD (no suffix) goes in TWO_TASK. TWO_TASK-VCSPROD

Yes Jim,you are right.I tried the same and it worked.Thanks for your valuable time and words.Thanks a lot.

Hi,

I am new to this Forum and i need to know more about unix.

Please any body help me in how to connect oracle from unix script and how to access the data from oracle database from unix.

why hesitate to start new thread for your own topic?

since this is your first post, I advice you to read the forum rules carefully.

please visit here for information about beginners.
unix beginners


for connection to oracle, you can try

Code:

$ORACLE_HOME/bin/sqlplus $uname/$passwd@$sid << END
<<your sql queries goes here>>
<<...>>
exit
END

Hope it helps.