recreate Repository
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: recreate Repository

  1. #1
    Join Date
    Jun 2008
    Posts
    5

    recreate Repository

    Hello! I want recreate Repository. Version Oracle is 10.1.0.5.0
    I do delete repository.
    Command:
    /opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.250)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBa se)))" -sys_password password -action drop
    Log:
    [05-06-2008 07:49:45] Checking SYS Credentials ...
    [05-06-2008 07:49:45] OK.
    [05-06-2008 07:49:45] Dropping the repository..
    [05-06-2008 07:49:45] Quiescing DB ...
    [05-06-2008 07:49:45] Failed.
    [05-06-2008 07:49:45] Checking for Repos User ...
    [05-06-2008 07:49:45] Does not Exist.
    [05-06-2008 07:49:45] Repos User does not exist ... Continuing with cleanup ...
    [05-06-2008 07:49:45] Dropping Roles/Synonymns/Tablespaces ...
    [05-06-2008 07:49:46] Done.
    [05-06-2008 07:49:46] Unquiescing DB ...
    [05-06-2008 07:49:46] Done.
    [05-06-2008 07:49:46] Dropped Repository Successfully.
    Next I do create repository.
    Command
    /opt/app/oracle/10.1.0/sysman/admin/emdrep/bin/RepManager -connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.250)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBa se)))" -sys_password password -action create
    Log(general part):
    [05-06-2008 07:49:59] Checking SYS Credentials ...
    [05-06-2008 07:49:59] OK.
    [05-06-2008 07:49:59] Checking DB Init Parameters ...
    [05-06-2008 07:49:59] OK.
    [05-06-2008 07:49:59] Checking for Repos User ...
    [05-06-2008 07:49:59] Does not Exist.
    [05-06-2008 07:49:59] Loading necessary DB objects ...
    [05-06-2008 07:49:59] Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ...
    [05-06-2008 07:49:59] Exists.
    [05-06-2008 07:49:59] DBMS POOL package exists.
    [05-06-2008 07:49:59] Done Loading necessary DB objects
    [05-06-2008 07:49:59] Creating repos user ...
    [05-06-2008 07:50:05] Done.
    [05-06-2008 07:50:05] Creating EM Schema ...
    SP2-0310: unable to open file "/opt/app/oracle/10.1.0/sysman/admin/emdrep/sql/ocs/latest/ovf/ovf_pkgdefs.sql"
    declare
    *
    ERROR at line 1:
    ORA-20204: User does not exist: SYSMAN
    ORA-06512: at "SYSMAN.MGMT_USER", line 122
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 142
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 78
    ORA-06512: at line 16


    [05-06-2008 08:08:31] Failed.
    [05-06-2008 08:08:31] Repository Creation failed. Failed to create repository schema.
    Log other:
    Enter repository user name : sysman
    Enter repository user password :
    Enter MetaLink user name :
    Enter MetaLink user password :
    Getting temporary tablespace from database...
    Found temporary tablespace: TEMP
    Checking SYS Credentials ... OK.
    Checking DB Init Parameters ... OK.
    Checking for Repos User ... Does not Exist.
    Loading necessary DB objects ...
    Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists.
    DBMS POOL package exists.
    Done Loading necessary DB objects
    Creating repos user ... Done.
    Creating EM Schema ... Failed.
    Repository Creation failed. Failed to create repository schema.

    Next I do query:
    select count(*) from all_users
    where username = UPPER('sysman');
    Result: 1
    Where is problem?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool emca?

    Why are you not using /opt/app/oracle/10.1.0/bin/emca?
    .
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jun 2008
    Posts
    5
    I do start emca.
    Log:
    DBConsole is already configured for the database samotlor
    Would you like to re-configure DBConsole for the specified database? [yes/no]: yes
    Make sure that DBConsole has been shutdown
    When you are ready to continue, press
    Jun 11, 2008 10:57:46 AM oracle.sysman.emcp.EMConfig updateReposVars
    INFO: Updating file /opt/app/oracle/10.1.0/sysman/emdrep/config/repository.variables ...
    Jun 11, 2008 11:00:41 AM oracle.sysman.emcp.EMConfig createRepository
    INFO: Creating repository ...
    Jun 11, 2008 11:00:41 AM oracle.sysman.emcp.EMConfig perform
    INFO: Repository was created successfully
    Jun 11, 2008 11:00:43 AM oracle.sysman.emcp.EMConfig stopOMS
    INFO: Stopping the DBConsole ...
    Jun 11, 2008 11:00:50 AM oracle.sysman.emcp.EMConfig addPortEntries
    INFO: Updating file /opt/app/oracle/10.1.0/install/portlist.ini ...
    Jun 11, 2008 11:00:50 AM oracle.sysman.emcp.EMConfig updateEmdProps
    INFO: Updating file /opt/app/oracle/10.1.0/sysman/config/emd.properties ...
    Jun 11, 2008 11:00:51 AM oracle.sysman.emcp.EMConfig updateConfigFiles
    INFO: targets.xml file is updated successfully
    Jun 11, 2008 11:00:51 AM oracle.sysman.emcp.EMConfig updateEmomsProps
    INFO: Updating file /opt/app/oracle/10.1.0/sysman/config/emoms.properties ...
    Jun 11, 2008 11:00:51 AM oracle.sysman.emcp.EMConfig updateConfigFiles
    INFO: emoms.properties file is updated successfully
    Jun 11, 2008 11:00:52 AM oracle.sysman.emcp.EMConfig startOMS
    INFO: Starting the DBConsole ...
    Jun 11, 2008 11:02:29 AM oracle.sysman.emcp.EMConfig perform
    INFO: DBConsole is started successfully
    Jun 11, 2008 11:02:29 AM oracle.sysman.emcp.EMConfig perform
    INFO: >>>>>>>>>>> The Enterprise Manager URL is http://Oracle:5500/em <<<<<<<<<<<
    Enterprise Manager configuration is completed successfully
    FINISHED EMCA at Wed Jun 11 11:02:29 NOVST 2008
    Next. I do start IE.
    I reseive:
    "The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation."
    Really: database open.
    Where is problem.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool you could login, right?

    EM is working now and you could login, right?

    Check that the db is actually up and in non-restricted mode, otherwise shutdown immediate and startup normal.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Jun 2008
    Posts
    5
    Quote Originally Posted by LKBrwn_DBA
    EM is working now and you could login, right?

    Check that the db is actually up and in non-restricted mode, otherwise shutdown immediate and startup normal.
    EM is working now and I don't could login. When I start IE and wont login, I receive:
    "The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation."

    DB is actually up and non-restricted mode. I can shutdown immediate and startup normal in the Monday.

  6. #6
    Join Date
    Jun 2008
    Posts
    5
    Hello! I do shutdown immediate and startup normal. Next, I do start IE and I receive:
    "The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation."

  7. #7
    Join Date
    Aug 2008
    Posts
    3
    Hello, Grigoriy! Have you contrived to solve your issue?

  8. #8
    Join Date
    Jun 2008
    Posts
    5
    Quote Originally Posted by WillI'm
    Hello, Grigoriy! Have you contrived to solve your issue?
    Hello, WillI'm! No I haven't !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width