Or do I have to always launch it with sqlplus someuser/somepw@somehost ?

I have set the ORACLE_SID to the correct string (same as somehost above). is there something else I need to set?

Sorry I am a complete noobie! I did get Oracle 10g on Fedora Core 2 though (Phew!)


Dean

I no longer have a system that uses Oracle but I think I remember that you could set the ORACLE_SID like so ...

In Bash

$ export ORACLE_SID=somehost
$ sqlplus someuser/password

In csh

% setenv ORACLE_SID somehost
% sqlplus someuser/password

Damn that was fast!

I 'think' I tried that already:





[oracle@localhost bin]$ echo $ORACLE_SID
act9
[oracle@localhost bin]$ sqlplus act_jun/secret

SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jul 1 15:41:28 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory



It works if I type

$ sqlplus act_jun/secret@act9

though.

Is there some difference in the way I am doing this?
(I set those variables in the .bash_profile file)

DeanB

Like I said I don't have Oracle anymore ...

Take a look here

http://forums.oracle.com/forums/thre...f534944#717368