Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: svrmgrl ORA-00900: Can't run sql from svrmgrl?

Re: svrmgrl ORA-00900: Can't run sql from svrmgrl?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 27 Dec 1999 21:47:08 +0100
Message-ID: <946327700.11954.0.pluto.d4ee154e@news.demon.nl>


You could try
@?/rdbms/admin/catalog.sql (where ? is an Oracle abbrev for =
$ORACLE_HOME)
Maybe the @ needs to be escaped in your installation, like this \@

replacing the @ by start doesn't work as far as I remember.

Hth,
--
Sybrand Bakker, Oracle DBA
  Stephen Hurrell <hurrells_at_hotmail.com> wrote in message = news:3867C926.EFC7CE7D_at_hotmail.com...
  Hello.

  1. I do have $ORACLE_HOME, et all defined in my environment. How do I run the catalog, catproc, etc part of my 8.0.5 -> 8.0.5.2.2 = Y2K upgrade?

  STeve
  hurrells_at_hotmail.com     

$ svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.2.2 - Production With the Partitioning and Objects options PL/SQL Release 8.0.5.2.1 - Production

SVRMGR> connect internal ;
Connected.
SVRMGR> @/u01/app/oracle/product/8.0.5/rdbms/admin/catalog.sql ; /u01/app/oracle/product/8.0.5/rdbms/admin/catalog.sql *
ORA-00900: invalid SQL statement
SVRMGR> Received on Mon Dec 27 1999 - 14:47:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US