| Error Logging into Oracle Database [message #195799] |
Mon, 02 October 2006 09:01  |
jilsoke
Messages: 1
Registered: October 2006
|
Junior Member |
|
|
I have Four Oracle 9i Instances running in a hp machine. When I log in as system/password@SID, it wrks fine but when I log in as system/password without sepicifying SID, I get the error 'Oracle not available'. Please help me resolve this error, Or How can I set one Instance to be the default. I have tried $ORACLE_SID=SID but this does not work.
Thanks
Julius Okello
|
|
|
|
|
|
|
|
| Re: Error Logging into Oracle Database [message #196599 is a reply to message #195799] |
Fri, 06 October 2006 02:31  |
bwetkstr
Messages: 114
Registered: August 2005
|
Senior Member |
|
|
just a test:
set your oracle sid and then echo the oracle_sid variable.
windows:
set ORACLE_SID=db
echo %ORACLE_SID%
linux
export ORACLE_SID=db
echo $ORACLE_SID
Or in Linux you can also set your oracle enviroment
> . oraenv
> db
> sqlplus '/ as sysdba' (if you are the right os user that is)
|
|
|
|
|
|
| Re: Error Logging into Oracle Database [message #198052 is a reply to message #196758] |
Sat, 14 October 2006 02:54 |
pareshjavkar
Messages: 7
Registered: October 2006
Location: Mumbai
|
Junior Member |
|
|
In Windows:
cmd> set oracle_sid=db01
cmd> sqlplus /nolog
SQL> conn username/password
(Also, you can set one instance to default:
1. Right CLick on MyComputer
2. Select Advanced Tab
3. Select Environment_Variables Tab
4. User Variables for Administration
5. Click New
6. Add oracle_sid in variable window and db01 (sid name) in Value window)
In Linux:
$ export ORACLE_SID=db01
$ sqlplus /nolog
SQL> conn username/password
(Also, you can hardcore the changes in .bash_profile present for oracle user for setting the environment
Just Add "export ORACLE_SID=db01" in your .bash_profile)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
