OraFAQ Forum: Networking and Gateways » sqlplus from run command

Home » RDBMS Server » Networking and Gateways » sqlplus from run command

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

sqlplus from run command [message #125614]

Tue, 28 June 2005 01:23

aparnapallavi
Messages: 28
Registered: June 2005

Junior Member

I have loaded oracle 9i. i have installed it on my k drive. during installation there was an error with a tns exe file. so now everytime i run the enterprise manager i have to start the tns listener manually from the services. but the sqlplus from the run command in the start menu is not working. but initally it had worked. could someone tell me what is wrong??

Report message to a moderator

Re: sqlplus from run command [message #125620 is a reply to message #125614]

Tue, 28 June 2005 01:34

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Check the value of PATH variable on your system. You may need to aapend it and add path for bin directory in Oracle home to this variable.

Regds
Girish

Report message to a moderator

Re: sqlplus from run command [message #125621 is a reply to message #125620]

Tue, 28 June 2005 01:36

aparnapallavi
Messages: 28
Registered: June 2005

Junior Member

could please explain a little bit more clearly what exactly i am supposed to do.

Report message to a moderator

Re: sqlplus from run command [message #125623 is a reply to message #125621]

Tue, 28 June 2005 01:42

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

To view contents of Path variable
On command prompt type PATH.
This will display all directory paths that have been appended to this PATH variable. This is a system variable used for defining environment.

or else:

Right click on "My Computer"
Select "Properties"
Select "Advanced"
Select "Environment Variables"
Check for Path variable under "System Variables"
Edit this variable and add the directory path for bin directory of oracle to this variable.

This will resolve the isue for you.

Regds
Girish

Report message to a moderator

Re: sqlplus from run command [message #125625 is a reply to message #125623]

Tue, 28 June 2005 01:49

aparnapallavi
Messages: 28
Registered: June 2005

Junior Member

the path is set as you asked me to. but i am still getting the same problem. the error i am getting is " Windows cannot find 'sqlplus'. make sure you have typed the name correctly and then try again."

Report message to a moderator

Re: sqlplus from run command [message #125626 is a reply to message #125625]

Tue, 28 June 2005 01:51

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Can u pls post the current value of Path here on this message.

Also pls post the location of sqlplus.exe as well.

Report message to a moderator

Re: sqlplus from run command [message #125631 is a reply to message #125614]

Tue, 28 June 2005 02:07

aparnapallavi
Messages: 28
Registered: June 2005

Junior Member

K:\oracle\ora90\bin;K:\oracle\ora90\Apache\Perl\5.00503\bin\mswin32-x86;C:\Program Files\Oracle\jre\1.1.8\bin;%SYSTEMROOT%\system32;%SYSTEMROOT%;%SYSTEMROOT%\system32\WBEM

this is path value

path for the sqlplus.exe file
sqlplus.exe-35D06534.pf ---- c:/windows/prefetch
sqlplus.exe ----- k:\oracle\ora90\bin

Report message to a moderator

Re: sqlplus from run command [message #125633 is a reply to message #125631]

Tue, 28 June 2005 02:11

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Have u rebooted or relogged-in (logged-out & logged-in) into your system after appending this value of path?
If no, pls do that and then check.

Report message to a moderator

Re: sqlplus from run command [message #126118 is a reply to message #125614]

Fri, 01 July 2005 01:59

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I think ur sqlplus problem has been resolved till now. So lets talk abt listener :

Go to services -->right click on listener-->properties and in General type choose startup type - AUTOMATIC.

And even it doesnt work after rebooting then u can delete this listener from Net manager and Add a new listener .

I think that would resolve ur problem.

Tarun

Report message to a moderator

Previous Topic:	Oracle remote connect problem
Next Topic:	Can i log to a remote oracle 920i database from an oracle 80 client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 22:17:59 CDT 2024