Re: Change oracle_sid in 9i ?

David Nguyen wrote:

> Help please!!!
>
> I did going into a DOS prompt and do the following:
>
> C:\set ORACLE_SID = DAVID
> (My SID is DAVID)
>
> I did not set ORACLE_HOME because 2 of my DATABASES is in the same box.
>
> It still doesn't work and I don't have a clue.
>
> David
>
> DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E57CCAF.4BE1B60C_at_exesolutions.com>...
> > David Nguyen wrote:
> >
> > > No I never get any error message. I run my application it work fines
> > > for both databases and I have 2 seperate services and 2 seperate
> > > intances. I access database no problem both from client and server
> > > thru ODBC
> > > I'm also access both database no problem thru SQL application because
> > > when I use SQL plus it ask for USERID/PASSWORD and string and the
> > > string is the intance and I access both intances no problem
> > >
> > > To run exp/imp I have to run exp/imp ID/PASSWORD_at_intance it do work
> > > for both database.
> > >
> > > However, if I click on EXP/IMP from BIN folder it doesn't give me a
> > > choice to connect to an intance that I want but default to a second
> > > database
> > >
> > > I know I need to change ORACLE_SID to a SID that I want
> > >
> > > But how to change a SID that's my question?
> > >
> > > Thanks
> > >
> > > David
> > >
> > > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E56AB2A.238E19D5_at_exesolutions.com>...
> > > > David Nguyen wrote:
> > > >
> > > > > Hi all,
> > > > >
> > > > > I created a second database in Oracle 9i windows 2000 (in the same
> > > > > box). Now I try to run EXP/IMP and it keep EXP/IMP the data from my
> > > > > second database. How can I switching back to EXP/IMP of my first
> > > > > database.
> > > > >
> > > > > Panic ! please help
> > > > >
> > > > > David
> > > > >
> > > > > I'm appreciated if someone send a reply back to my email:
> > > > > nguyend4_at_hotmail.com
> > > >
> > > > Read your post above. I've no doubt you are in a panic. But from what
> > > > you wrote I can't figure out why? You wouldn't happen to have an
> > > > ORA-##### message you're keeping secret would you?
> > > >
> > > > Did you reset ORACLE_SID? ORACLE_HOME?
> > > >
> > > > Daniel Morgan
> >
> > Never forget that Windows is just a GUI shell still running on DOS. So run EXP and IMP from the DOS
> > command line as Liggs says. To alter the environment variables just:
> >
> > SET ORACLE_SID=
> > SET ORACLE_HOME=
> >
> > and provide the appropriate values.
> >
> > Daniel Morgan

Drop the spaces it is not

ORACLE_SID = DAVID but rather ORACLE_SID=DAVID

Your explanation about setting ORACLE_HOME makes no sense. Set ORACLE_HOME=directory one directory above BIN. And if it doesn't work then post the entire ORA-##### error message and all text. "It still doesn't work and I don't have a clue" doesn't give anyone a clue for helping you either.

Daniel Morgan Received on Mon Feb 24 2003 - 15:54:28 CST