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
Messages: 75
Registered: February 2005

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
ORACLE_SID=PROD2: is not an identifier

Am I missing something very basic here?

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: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
$ ORACLE_SID=prod2; export ORACLE_SID
The syntax depends on your shell.


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
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: Tue Oct 25 17:44:47 CDT 2016

Total time taken to generate the page: 0.10616 seconds