Home » Infrastructure » Windows » Cant Access SQLPLUS from Command Prompt
Cant Access SQLPLUS from Command Prompt [message #263677] Thu, 30 August 2007 13:34 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi Experts,

I have this problem on my system, actually I have 2 hard drives
C(main) and E(slave) but when i formatted and re-install windows
my C hard drive turned E and E turned C. D is my CD drive.

Now I partioned my main hard drive E to F, G, & H and installed
oracle on G.

Now if I try to open SQLPLUS, RMAN, EXPDP or IMPDP from
Command Prompt it gives me this message:

'SQLPLUS' is not recognized as an internal or external command,
operable program or batch file.

Please what do I do?

Thanks in advance.

Cherish
Re: Cant Access SQLPLUS from Command Prompt [message #263680 is a reply to message #263677] Thu, 30 August 2007 13:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check if %ORACLE_HOME%\bin is in your PATH.

Regards
Michel
Re: Cant Access SQLPLUS from Command Prompt [message #263708 is a reply to message #263680] Thu, 30 August 2007 17:25 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Yes it is.

I really don't know what to do next.

Thanks.
Re: Cant Access SQLPLUS from Command Prompt [message #263753 is a reply to message #263708] Thu, 30 August 2007 23:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You could always change active directory to %ORACLE_HOME%\BIN and run those programs from there.

Could you do the following (so that we could SEE how it looks like)?
Open Windows Explorer, navigate to BIN directory of your ORACLE_HOME and copy-paste the whole path to it (for example,

C:\oracle\product\10.2.0\db_1\BIN).

Now go to Control Panel, open run System, go to Advanced tab, Environment Variables, Edit PATH variable and copy-paste its contents (for example,

%path%;C:\oracle\product\10.2.0\db_1\bin;C:\oracle\product\90401\dev_suit\jdk\jre\bin\classic;C:\oracle\product\90401\dev_suit\jdk\jr e\bin;C:\oracle\product\90401\dev_suit\jdk\jre\bin\client;C:\oracle\product\90401\dev_suit\jlib;C:\oracle\product\90401\dev_suit\bin; C:\oracle\product\90401\dev_suit\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;)
Re: Cant Access SQLPLUS from Command Prompt [message #264102 is a reply to message #263753] Fri, 31 August 2007 15:32 Go to previous message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks. Everything is fine now.

I set the path as:
'G:\oracle\base\home\bin;G:\oracle\base\home\jre\1.4.2\bin\client;G:\oracle\base\home\jre\1.4.2\bin;%ORACLE_HOME%\bin'
and it's now fine.

Accept my gratitude.

Stay blessed.

Cherish
Previous Topic: ORA-01565: error in identifying file '+DATA/asm/spfileasm.ora'
Next Topic: problems creating new database
Goto Forum:
  


Current Time: Fri Mar 29 07:19:04 CDT 2024