ORA home help

[scottyjohn]

Hi all,
I have an issue which is driving me bananas! I have written a script on windows machine which calls an sqlplus -s script. Yesterday I tested it and it worked no problem, but today I get the error SP2-0734 saying it cannot recognise the command.
I have ors81 and ora92 homes, and have tried to select either of the home paths usinf the home selector utility but neither works.
Can anyone help? Its on Win2003 server. I can get it to run successfully on a different machine which only has ora92.
Thanks in advance!

John

 

[KenCunningham]

Check your PATH - is ora81 home before ora92 in it?

I want to be good, is that not enough?

 

[scottyjohn]

Hi ora81 seems to be before the ora92. Is this an issue?

John

 

[KenCunningham]

Might be - can you reverse it and give it a go? I've found Oracle locator Express:

http://www.dbmotive.com/oracle_home_selector.php

to be useful in the past too.

I want to be good, is that not enough?

 

[scottyjohn]

Hi all,
Tried altering the path but it screwed it completely, so uninstalled all clients and then reinstalled the 9.2 client and its all working fine now, thanks for all your help guys.

John

 

[KenCunningham]

Glad you sorted it, and thanks for posting back to say what you did.

I want to be good, is that not enough?