Home » Infrastructure » Linux » sqlplus in oracle 10g on linux 5 (Linux 5.1)
sqlplus in oracle 10g on linux 5 [message #562232] Mon, 30 July 2012 09:45 Go to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i have installed oracle 10g on linux 5.1 successfully.
but now i want to launched sqlplus. i never find it.
how to configure it.
and where i can find it?
thanks
Re: sqlplus in oracle 10g on linux 5 [message #562233 is a reply to message #562232] Mon, 30 July 2012 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which installation (type) did you make?

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562234 is a reply to message #562233] Mon, 30 July 2012 10:35 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

oracle 10g release 2 and os linux 5.1..
also there is problem with the listner start.
please help me the listner start and stop method and where i should write the lisnrctl start command.
because i write this command in root terminal but this is not recognized..

Re: sqlplus in oracle 10g on linux 5 [message #562236 is a reply to message #562234] Mon, 30 July 2012 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You gave your versions, I asked you about installation type: server, client? Which client? Instant client? Developer one? Administrator one? With databa utilities or not?

You say "i want to launched sqlplus. i never find it", what did you try? Post it, that is copy and paste what yu did and got.

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562240 is a reply to message #562236] Mon, 30 July 2012 12:19 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i have installed oracle 10g on linux server.
i want to login as scott or sys using sqlplus but where i find sqlplus.
when i write the command sqlplus in root terminal it return not valid command.
Re: sqlplus in oracle 10g on linux 5 [message #562248 is a reply to message #562240] Mon, 30 July 2012 12:57 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

also i want to share some detail. actually when i issue lsnrctl start command in root terminal it return command not found .
whant is?
i want to start the db em....
but this is not working....
Re: sqlplus in oracle 10g on linux 5 [message #562250 is a reply to message #562248] Mon, 30 July 2012 13:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't answer my questions, we can't help.
I didn't post them to bother you but because they are required to know what you have and how to fix your problem.

Regards
Michel

[Updated on: Mon, 30 July 2012 13:01]

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562252 is a reply to message #562250] Mon, 30 July 2012 13:07 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i have inswared your both question.i have server based linux installed and db is also server not client.
Re: sqlplus in oracle 10g on linux 5 [message #562253 is a reply to message #562252] Mon, 30 July 2012 13:18 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You mean you install a server version of Oracle.
In this case you should have sqlplus in $ORACLE_HOME/bin.
Show us what you do and get.
Post the result of:
id
env | sort
which sqlplus
ls -ld $ORACLE_HOME
ls -l $ORACLE_HOME


Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562474 is a reply to message #562253] Wed, 01 August 2012 10:45 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

[root@localhost ~]# su oracle
[oracle@localhost root]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
[oracle@localhost root]$ export ORACLE_SID=orcl
[oracle@localhost root]$ lsnrctl status
bash: lsnrctl: command not found
[oracle@localhost root]$ lsnrctl start
bash: lsnrctl: command not found


i issue this command to start the lisnter of oracle but not worked.why... please guide me..
Re: sqlplus in oracle 10g on linux 5 [message #562476 is a reply to message #562474] Wed, 01 August 2012 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ This is no what I asked
2/ Use ". oraenv" to set your Oracle environment for a database

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562500 is a reply to message #562232] Wed, 01 August 2012 12:56 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i can't understand your command.
i want to set env so that i start listner.
how i can do this... i post earlier the oracle_home path..
please write the complete command.
Re: sqlplus in oracle 10g on linux 5 [message #562501 is a reply to message #562500] Wed, 01 August 2012 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you not understand?
Just type:
. oraenv

or
. . /usr/local/bin/oraenv

and answer ORCL or orcl when it asks for "ORACLE_SID?"
This is THE starting point, after that you could use Oracle commands, before you can't.
Maybe you should have a look at your Oracle version documentation for Linux (http://www.oracle.com/pls/db102/portal.portal_db?selected=3).

Regards
Michel

[Updated on: Wed, 01 August 2012 13:12]

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562502 is a reply to message #562500] Wed, 01 August 2012 13:09 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
export PATH=$ORACLE_HOME/bin:$PATH

lsnrctl status
Re: sqlplus in oracle 10g on linux 5 [message #562505 is a reply to message #562232] Wed, 01 August 2012 13:37 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

[root@localhost ~]# su oracle

[oracle@localhost root]$ PATH=$ORACLE_HOME/bin:$PATH

[oracle@localhost root]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

[oracle@localhost root]$ lsnrctl start
bash: lsnrctl: command not found

[oracle@localhost root]$
Not worked....
Re: sqlplus in oracle 10g on linux 5 [message #562506 is a reply to message #562505] Wed, 01 August 2012 14:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, try what I said, it is THE correct way to do it.

Without saying that it is silly to set ORACLE_HOME AFTER PATH when PATH uses ORACLE_HOME.
If you do it as I said you CAN'T make this kind of error and you are SURE to correctly set you environment.

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562686 is a reply to message #562506] Fri, 03 August 2012 07:39 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

ORACLE_BASE
ORACLE_HOME
TNS_ADMIN
ORACLE_SID
PATH

please give me example how these variable are set....
explain with example like oracle_home is set ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1.
how the other variable are set????
Re: sqlplus in oracle 10g on linux 5 [message #562694 is a reply to message #562686] Fri, 03 August 2012 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using "oraenv"!

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #562703 is a reply to message #562506] Fri, 03 August 2012 10:03 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

[oracle@localhost ~]$ ./usr/local/bin/oraenv

bash: /usr/local/bin/oraenv: No such file or directory

i issue this command in oracle user but it not working...

Re: sqlplus in oracle 10g on linux 5 [message #562708 is a reply to message #562703] Fri, 03 August 2012 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A space is missing between . and / in your command line.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Use find to search for oraenv, if you don't find it then your install is not correct, reinstall Oracle.

Regards
Michel

Re: sqlplus in oracle 10g on linux 5 [message #562998 is a reply to message #562703] Tue, 07 August 2012 13:18 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i am try once again to installl the oracle 10g from scratch....
i do all the step when i call the universall installer it return this error......

[oracle@lnxdb database]$ ./runInstaller


Starting Oracle Universal Installer...

Checking installer requirements...


Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2


Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-08-08_10-54-16AM. Please wait ...

[oracle@lnxdb database]$ Exception in thread "main" java.lang.InternalError:
Can't connect to X11 window server using 'localhost:0.0' as the value of the DISPLAY variable.

at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)

at sun.awt.X11GraphicsEnvironment.<clinit>(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown Source)

at java.awt.Window.init(Unknown Source)

at java.awt.Window.<init>(Unknown Source)

at java.awt.Frame.<init>(Unknown Source)

at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)

at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)

at oracle.sysman.oio.oioc.OiocOneClickInstaller.<init>(OiocOneClickInstaller.java:378)

at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)


PLEASE HELP TO SOLVED THIS PROBLEM...

Re: sqlplus in oracle 10g on linux 5 [message #563000 is a reply to message #562998] Tue, 07 August 2012 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can't connect to X11 window server using 'localhost:0.0' as the value of the DISPLAY variable.


You have to make xclock works FIRST.
Currently this is NOT an Oracle problem.

Regards
Michel
Re: sqlplus in oracle 10g on linux 5 [message #563001 is a reply to message #563000] Tue, 07 August 2012 13:40 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

please explian how i can resolve this...
how i can set xclock....
i login as su - oracle..
and issue this command..
DISPLAY=lnxdb:0.0; export DISPLAY------------lnxdb is my machine name...

please help..
Re: sqlplus in oracle 10g on linux 5 [message #563015 is a reply to message #563001] Tue, 07 August 2012 21:07 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
>i login as su - oracle..
above is 100% GUARANTEED to NOT work!

you must connect to DB Server be doing as below or the functional equivalent thereof

ssh -X oracle@DB_Server
# now immediately after using command above, then do as below against DB Server OS

id
env | sort

COPY results from 2 commands above then PASTE all back here
Re: sqlplus in oracle 10g on linux 5 [message #563100 is a reply to message #563015] Wed, 08 August 2012 10:41 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

Thanks your reply..
my problem is solve...

once again thanks to all the members..
Re: sqlplus in oracle 10g on linux 5 [message #563103 is a reply to message #563100] Wed, 08 August 2012 11:27 Go to previous message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How? please explain the root of the problem and its solution, the forum is not just for you but for all that search for some answers.

Regards
Michel
Previous Topic: 11gR2 installation on REL5.5
Next Topic: Linux Memory utilization
Goto Forum:
  


Current Time: Tue Sep 02 13:04:27 CDT 2014

Total time taken to generate the page: 0.13167 seconds