3

Is there any way we can specify Oracle Service Name in UNIX Profile?

I know that there is an environment variable ORACLE_SID for specifying SID in the Profile,

But how about service name? If there is, then can we remove ORACLE_SID once we set the Service Name in the Profile?

  • Can you explain what you are trying to achieve? The question doesn't make much sense to me. In Linux-world, AIUI the SID is a combination of ORACLE_HOME and ORACLE_SID which uniquely identifies a single database instance. – Phil Sumner Jul 17 '14 at 9:23
1

Use the TWO_TASK variable and set it to [server]/[service]

export TWO_TASK=server.example.com/mydb

This will override ORACLE_SID and make a sqlnet connection to the DB.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.