Advertisement

01.18.2007 at 02:29AM PST, ID: 22127085
[x]
Attachment Details

ORA 10g on Unix (solaris) server : How can I set default SID to connect as USER/PWD instead of USER/PWD@SID ?

Asked by Hilaire in Oracle Database

Tags: sid, default, oracle, set, sqlplus

Hi experts,
I've got a new Oracle install on a test DB (migrating 9i to 10g)

A set of scripts that run on the server don't work, they're expecting a connect string with a pattern

sqlplus -s USER/PWD@SID ........

rather than

sqlplus -s USER/PWD ......
(which works on the production 9i DB)

That's is pretty annoying  ^^

I remember there's an option somewhere to get rid of this problem, but my attempts to find it have failed so far ...
Any suggestions welcome

Hilaire
Start Free Trial
[+][-]01.18.2007 at 02:54AM PST, ID: 18339570

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]01.18.2007 at 03:06AM PST, ID: 18339619

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.18.2007 at 03:28AM PST, ID: 18339760

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: sid, default, oracle, set, sqlplus
Sign Up Now!
Solution Provided By: sfs_dba
Participating Experts: 4
Solution Grade: A
 
 
[+][-]01.18.2007 at 05:04AM PST, ID: 18340392

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]01.18.2007 at 05:35AM PST, ID: 18340607

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.18.2007 at 05:52AM PST, ID: 18340736

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.18.2007 at 11:37AM PST, ID: 18344080

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]01.18.2007 at 12:52PM PST, ID: 18344701

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32