Home » Infrastructure » Unix » unable to change SID on 10g (10g R2)
unable to change SID on 10g [message #305999] Wed, 12 March 2008 09:31 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

I have 3 databases on the same server. one of them is a 9i db and the other 2 are 10g.

The environment variables are set and the SID is set to Prod1. I want to login to the Prod2 daabase, and when I give this command
export ORACLE_SID=PROD2, i get this error below.
$ export ORACLE_SID=prod2
ORACLE_SID=prod2: is not an identifier
$ export ORACLE_SID=PROD2
ORACLE_SID=PROD2: is not an identifier

Am I missing something very basic here?

KV
Re: unable to change SID on 10g [message #306004 is a reply to message #305999] Wed, 12 March 2008 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
$ ORACLE_SID=prod2; export ORACLE_SID
The syntax depends on your shell.

Regards
Michel

Re: unable to change SID on 10g [message #306098 is a reply to message #305999] Wed, 12 March 2008 16:09 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Your ORACLE_HOME & PATH variables are going to change too. You may want to consider oraenv and/or coraenv in /usr/local/bin.
Previous Topic: Date function
Next Topic: passind date from shell script to java
Goto Forum:
  


Current Time: Thu Mar 28 18:56:38 CDT 2024