OraFAQ Forum: Linux » sqlplus in oracle 10g on linux 5

Home » Infrastructure » Linux » sqlplus in oracle 10g on linux 5 (Linux 5.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus in oracle 10g on linux 5 [message #562232]

Mon, 30 July 2012 09:45

irfankundi786@yahoo.com
Messages: 269
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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562233 is a reply to message #562232]

Mon, 30 July 2012 10:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which installation (type) did you make?

Regards
Michel

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562234 is a reply to message #562233]

Mon, 30 July 2012 10:35

irfankundi786@yahoo.com
Messages: 269
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..

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562236 is a reply to message #562234]

Mon, 30 July 2012 11:18

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562240 is a reply to message #562236]

Mon, 30 July 2012 12:19

irfankundi786@yahoo.com
Messages: 269
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.

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562248 is a reply to message #562240]

Mon, 30 July 2012 12:57

irfankundi786@yahoo.com
Messages: 269
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....

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562250 is a reply to message #562248]

Mon, 30 July 2012 13:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

irfankundi786@yahoo.com
Messages: 269
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.

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562253 is a reply to message #562252]

Mon, 30 July 2012 13:18

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562474 is a reply to message #562253]

Wed, 01 August 2012 10:45

irfankundi786@yahoo.com
Messages: 269
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..

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562476 is a reply to message #562474]

Wed, 01 August 2012 10:48

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ This is no what I asked
2/ Use ". oraenv" to set your Oracle environment for a database

Regards
Michel

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562500 is a reply to message #562232]

Wed, 01 August 2012 12:56

irfankundi786@yahoo.com
Messages: 269
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.

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562501 is a reply to message #562500]

Wed, 01 August 2012 13:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you not understand?
Just type:

. oraenv

. . /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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

export PATH=$ORACLE_HOME/bin:$PATH

lsnrctl status

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562505 is a reply to message #562232]

Wed, 01 August 2012 13:37

irfankundi786@yahoo.com
Messages: 269
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....

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562506 is a reply to message #562505]

Wed, 01 August 2012 14:01

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562686 is a reply to message #562506]

Fri, 03 August 2012 07:39

irfankundi786@yahoo.com
Messages: 269
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????

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562694 is a reply to message #562686]

Fri, 03 August 2012 08:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Using "oraenv"!

Regards
Michel

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562703 is a reply to message #562506]

Fri, 03 August 2012 10:03

irfankundi786@yahoo.com
Messages: 269
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...

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562708 is a reply to message #562703]

Fri, 03 August 2012 10:16

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #562998 is a reply to message #562703]

Tue, 07 August 2012 13:18

irfankundi786@yahoo.com
Messages: 269
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...

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #563000 is a reply to message #562998]

Tue, 07 August 2012 13:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #563001 is a reply to message #563000]

Tue, 07 August 2012 13:40

irfankundi786@yahoo.com
Messages: 269
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..

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #563015 is a reply to message #563001]

Tue, 07 August 2012 21:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #563100 is a reply to message #563015]

Wed, 08 August 2012 10:41

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

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

once again thanks to all the members..

Report message to a moderator

Re: sqlplus in oracle 10g on linux 5 [message #563103 is a reply to message #563100]

Wed, 08 August 2012 11:27

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	11gR2 installation on REL5.5
Next Topic:	Linux Memory utilization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:11:19 CST 2024