Solved

who is oracle repository owner?

Posted on 2004-04-02
5
1,233 Views
Last Modified: 2008-03-17
Hi,
I want to know how to check to know who is the repository owner?

Thank you very much!
0
Comment
Question by:fengq
5 Comments
 
LVL 8

Expert Comment

by:baonguyen1
ID: 10744161
Do you mean the OEM repository ?


To do this:    
1.  Connect as a DBA .  
2.  Query the owner.SMP_REP_VERSION or the owner.SMP_VDS_REPOS_VERSION table,  owner is the  actual schema returned from the first query.  

Hope this helps
0
 
LVL 8

Accepted Solution

by:
baonguyen1 earned 50 total points
ID: 10744188
I found this script to automate the above steps from Oracle.  Here are the instructions for running the script:
 
  1. Save the SQL script listed below to a file.
 
  2. Connect as a DBA user in SQL*Plus or SQL*Plus Worksheet.
 
  3. Run the following SQL command:  
 
       @file_name  
 
     where file_name is the full path and file name of the file saved  
     in Step #1.
 
 
Contents of the script file:
----------------------------
 
SET SERVEROUTPUT ON
 
        DECLARE  
        cursor1 integer;
        v_count number(1);
        v_schema dba_tables.owner%TYPE;
        v_version varchar2(10);
        v_component varchar2(20);
        v_i_name varchar2(10);
        v_h_name varchar2(30);
        stmt varchar2(200);
        rows_processed integer;
 
        CURSOR schema_array IS
        SELECT owner  
        FROM dba_tables WHERE table_name = 'SMP_REP_VERSION';
 
        CURSOR schema_array_v2 IS
        SELECT owner  
        FROM dba_tables WHERE table_name = 'SMP_VDS_REPOS_VERSION';
 
        BEGIN
        DBMS_OUTPUT.PUT_LINE ('.');
        DBMS_OUTPUT.PUT_LINE ('OEM REPOSITORY LOCATIONS');
 
        select instance_name,host_name into v_i_name, v_h_name from
        v$instance;
        DBMS_OUTPUT.PUT_LINE ('Instance: '||v_i_name||' on host: '||v_h_name);
 
        OPEN schema_array;
        OPEN schema_array_v2;
 
        cursor1:=dbms_sql.open_cursor;
 
        v_count := 0;
 
        LOOP -- this loop steps through each valid schema.
        FETCH schema_array INTO v_schema;
        EXIT WHEN schema_array%notfound;
        v_count := v_count + 1;
        dbms_sql.parse(cursor1,'select c_current_version, c_component from
        '||v_schema||'.smp_rep_version', dbms_sql.native);
        dbms_sql.define_column(cursor1, 1, v_version, 10);
        dbms_sql.define_column(cursor1, 2, v_component, 20);
 
        rows_processed:=dbms_sql.execute ( cursor1 );
 
        loop -- to step through cursor1 to find console version.
        if dbms_sql.fetch_rows(cursor1) >0 then
        dbms_sql.column_value (cursor1, 1, v_version);
        dbms_sql.column_value (cursor1, 2, v_component);
        if v_component = 'CONSOLE' then
        dbms_output.put_line ('Schema '||rpad(v_schema,15)||' has a repository
        version '||v_version);
        exit;
 
        end if;
        else
        exit;
        end if;
        end loop;
 
        END LOOP;
 
        LOOP -- this loop steps through each valid V2 schema.
        FETCH schema_array_v2 INTO v_schema;
        EXIT WHEN schema_array_v2%notfound;
 
        v_count := v_count + 1;
        dbms_output.put_line ( 'Schema '||rpad(v_schema,15)||' has a repository
        version 2.x' );
        end loop;
 
        dbms_sql.close_cursor (cursor1);
        close schema_array;
        close schema_array_v2;
        if v_count = 0 then
        dbms_output.put_line ( 'There are NO OEM repositories in this instance.');
        end if;
        end;
        /
0
 
LVL 1

Author Comment

by:fengq
ID: 10744638
Thanks, but I am actually looking for the answer for Oracle Designer Repository...
0
 
LVL 3

Expert Comment

by:dbms_chu
ID: 10751068
It looks like the Oracle Designer Repository installation is similar to the OEM repository installation in that the DBA/installer can define the repos_owner at install time.  However, according to the 9i SCM Repository Installation Guide, the default repos_owner is REPOS_MANAGER.

http://otn.oracle.com/documentation/designer.html


0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10755303
In RON you can see it in a property pallette.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DBLINKS From 11g to 8i 3 49
Email query results in HTML 6 31
Help with Oracle IF statment 5 26
setting local variables in a cursor block 3 20
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question