| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unable to run catalog.sql
Another idea would be to set the SQLPATH variable in your registry (remember if you do this to TAKE A BACKUP OF THE REGISTRY FIRST).
First of all map the network drive (it looks like you already have anyway) so that it is assigned a drive letter (D:\ in your case), as you don't really want to use the absolute path..
Open regedit or regedt32, and navigate to HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/<ORACLE_HOME>
and then either modify (if it is already there) or create a SQLPATH string, with a value of:
D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql
Maybe this will work?
Mark
-----Original Message-----
Sent: 28 November 2001 16:23
To: 'Mark Leith'
Mark:
This was a typo and I tried it again and got the same error message.
The absolute full path name is: My Network Places\Entire Network\Microsoft
Windows Network\Tech
net\Proteus\ Oracle\Ora81\RDMS\ADMIN\catalog.sql The server name is
Proteus.
I have run scripts to generate tablespaces referencing the D:\ drive and
they worked OK.
Any ideas?
Ken
-----Original Message-----
Sent: Wednesday, November 28, 2001 10:20 AM
To: Ken Janusz Subject: RE: Unable to run catalog.sql
Ken,
Taking a look at what you are trying to run, you have the path wrong:
@D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql
should be:
@D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql
^
|
Will this work?
Mark
-----Original Message-----
Sent: 28 November 2001 13:16
To: 'Mark Leith'
Mark:
This is what I have tried at the SQL*Plus prompt.
nic13> @D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql
SP2-0310: unable to open file "D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql"
Still get the error. Would this have anything to do with Telnet working or
not? My Telnet connection between my client PC and the server doesn't work.
Thanks,
Ken
-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk]
Sent: Wednesday, November 28, 2001 4:20 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Unable to run catalog.sql
It might be a PATH issue, try creating an entry in your PATH statement on
*your PC* that has the full path to the directory that holds catalog.sql.
-----Original Message-----
Sent: 27 November 2001 19:00
To: Multiple recipients of list ORACLE-L
I have tried to run catalog.sql from the sql*plus command line and keep
getting this error. sp2-0310 unable to open file "catalog.sql". I've use
the full path name with the same results. catalog.sql is on my PC and the
database is located on a server. I have run other commands from my client
machine with no problems.
What appears to be the problem?
TIA
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: ken.janusz_at_sufsys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Listsname of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: mark_at_cool-tools.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Listsname of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: mark_at_cool-tools.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 28 2001 - 11:03:27 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |