Re: Alter Database Question

ame..._at_iwc.net wrote:
> Hi All,
>
> We just created a new database. After running all the scripts and
> creating all the users, I try to enable ArchiveLog mode and get this:
>
> SVRMGR> ALTER DATABASE ARCHIVELOG;
> Statement processed.
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'DBMS_OUTPUT.GET_LINES' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'DBMS_OUTPUT.GET_LINES' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Any thoughts?

Posting the same question more than once won't get you any faster response.

You're using svrmgrl, so this must be some version of Oracle older than 9i (9.0.1), but you fail to specify *WHICH* release you're using. If you can't supply such information you shouldn't expect much in the way of a response. That being said it appears you haven't run the dbmsotpt.sql and prvtotpt.plb scripts, or you haven't run them as the proper user (SYS as SYSDBA (9i and later), or INTERNAL, for 8.1.7.x and older releases). I would connect internal and run these scripts; this should clear up your errors.

David Fitzjarrell Received on Wed Apr 06 2005 - 12:09:11 CDT