-
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?
-
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
-
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.
-
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
-
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.
-
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."
-
Hello, Grigoriy! Have you contrived to solve your issue?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|