SQL*Plus and Remote Share

[THoey]

I have an NT server with Oracle 8.1.7.1.5. I can do a RCMD from a DOS prompt on my machine, give it the server name, and then I am supposed to be basically running a DOS window on that server.

If I try to run a SQL*Plus script that way it fails and causes a Dr. Watson error. If I map a drive to that server and then just run the same command (providing the mapped drive info) the SQL runs fine. A call to SQL*Loader through the RCMD works fine.

Has anyone else seen this? Terry M. Hoey

 

[raygg]

On AIX I was getting this error
SP2-0310: unable to open file "/u01/app/oracle/product/8.1.7/rdbms/spcreate.sql"
when I was trying to execute by a connection thru sqlplus I made at the NT client. When I logged onto telnet at the client and connected, it was as if I was at the server so I started sqlplus that way and it worked fine.

 

[THoey]

An update to this. I made the trip over to the server room today, to try and install Remotely Possible and also to work on my batch files. Got Remotedly Possible installed.

I tried working on my scripts and got a Dr. Watson error everytime SQL*Plus is called. I receive the following error no matter what I do (Command Line, in batch, etc):

Message file SP1<lang>.msb not found....

This kicks off Dr. Watson, generates a log file and then lets my batch run to completion (unsuccessfully).

Any ideas what causes this? Or is this just a precursor error to something else? Really need some ideas on this, so, even if you aren't sure, I'll give anything a try.

Gonna go search Oracle's site... Terry M. Hoey

 

[THoey]

Nevermind. I kept messing with it and think I figured it out. I had an NT environment variable at the top of the file:

SET SQLPLUS=D:\ORACLE\ORA817\BIN\SQLPLUS.EXE

First, I REM'd (commented out) all the other &quot;executable lines&quot; except for the call to SQL*Plus, ran the bat file, that failed. Ran the command by itself from a DOS prompt, that worked. Cut and paste the line from the DOS prompt into a new batch file (by itself), that worked. Commented out every line from the bat file except the SQL*Plus call (including all the environment variables), that worked. Uncommented that one line, failed. Commented that one out and uncommented all other lines, script works like it is supposed to.

Any ideas? I copied this script from another NT server (works there), but it is only running Oracle 7.3.4.

If not, don't worry. I at least got it working.

<<beats head against desktop>> Terry M. Hoey

 

[sem]

Normally SP1<lang>.msb means that your program can not locate appropriate msb (messages) file. In fact it may be looked for just to inform you that you're successfully connected )) These files are located in sqlplus directory, defined by the key whose name is stored in HKLM/Oracle/PLUS_DFLT. If you have wrong environment you may repair it by adding appropriate

set PLUS80=<path_to_your_plus>

line to your batch file. Your environment may be corrupted due to executing remote commands by system account as most of services run. Or any other reason, to be honest I'm not experienced with RCMD on NT.