Re: WHAT IS A NON-REPOSITORY DATABSE???

In article <5jraq5$hr5_at_chronicle.concentric.net>, Nnoor_at_cris.com says...
>
>
>We are trying to get Oracle 7.3 Workgroup server running on
>Windows NT v4.0. It was set up without a hitch. After teh
>installation, the recommended SQL script was also run. But
>now we can only connect to the ENTERPRISE MANAGER as
>SYS or INTERNAL. Trying to login as any other user results
>in the following error message:
>"VOC-00114 The credentials you have supplied are for a non-
>repository database. Please verify that you have supplied the
>correct credentials and that necessary installation scripts have
>been run on the databse".
>
>It does not make sense to us. We even tried copying the SYS user
>using CREATE LIKE and even that new user wouldn't login to the
>ENTERPRISE MANAGER.
>
>We can login to otehr tools supplied with ORACLE or thru other
>third party Oracle tools (like Borland Delphi, DBArtisan, etc)
>using the userid of our choice. Why can't we do it with the
>ENTERPRISE MANAGER?
The Enterprise Manager needs a server-side repository (a set of database objects). You will need to install this repository by running the SQL script SMPCRE.SQL. On my Win95-PC this is located in <drive>:\ORAWIN95\SYSMAN\ADMIN (see "Oracle Enterprise Manager Installation Guide", page 1-7).

When starting the Enterprise Manager, you initially log in to the database that contains that repository, i. e. you log in as the repository owner (the user who executed above script and thus owns the repository objects). From what you write, it looks like you installed the repository as user SYS.
When you try to connect as another user, the repository, of course, is not found.

After that, you can perform various admin tasks for all your databases.

Hope that helps,
-- Robert Staedter

   University for Agriculture
   Vienna, Austria Received on Tue Apr 29 1997 - 00:00:00 CDT