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?

Improve this question
1
  • 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
    Commented Jul 17, 2014 at 9:23

1 Answer 1

Reset to default
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.

Improve this answer
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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