LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 07-01-2004, 02:29 PM   #1
deanbrown3d
Member
 
Registered: Jun 2004
Location: Central NJ, USA
Distribution: Red Hat / FC2
Posts: 66

Rep: Reputation: 15
Can I make sqlplus use a default hostname?


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
 
Old 07-01-2004, 02:37 PM   #2
SheldonPlankton
Member
 
Registered: Jun 2004
Posts: 129

Rep: Reputation: 15
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
 
Old 07-01-2004, 02:40 PM   #3
deanbrown3d
Member
 
Registered: Jun 2004
Location: Central NJ, USA
Distribution: Red Hat / FC2
Posts: 66

Original Poster
Rep: Reputation: 15
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

Last edited by deanbrown3d; 07-01-2004 at 02:42 PM.
 
Old 07-01-2004, 03:00 PM   #4
SheldonPlankton
Member
 
Registered: Jun 2004
Posts: 129

Rep: Reputation: 15
Like I said I don't have Oracle anymore ...

Take a look here

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make sshd answer only on a certain hostname ? michaelsanford Linux - Security 3 07-18-2005 03:19 PM
How can I make Windows see my Linux's hostname? ExCIA Linux - Networking 4 04-24-2005 08:26 PM
net-tools make: *** [hostname.o] Error 1 ADDY Linux From Scratch 5 11-16-2004 03:37 AM
How to make Apache show different hostname? mac_phil Linux - Software 2 05-11-2004 12:03 PM
How to make change in hostname beowulf405 Linux - General 4 03-12-2004 10:24 PM


All times are GMT -5. The time now is 07:27 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration