以前的步骤不太完整和正确,现在把我的实验共享出来。
GC重装的步骤:
一.在资料库删除下面信息
1drop user sysman
2.drop user mgmt_view
3. select 'drop public synonym '||object_name||';' from dba_objects where status='INVALID' and OBJECT_NAME LIKE 'MGMT%'
用这个命令输出,public同义词,然后删除
Spool出一个sql文件,然后直接运行该sql就成
4.应该删除这个表空间:
/u01/app/oracle/oradata/EMREP/mgmt.dbf
MGMT_TABLESPACE
/u01/app/oracle/oradata/EMREP/mgmt_ecm_depot1.dbf
MGMT_ECM_DEPOT_TS
SQL> select username,default_tablespace from dba_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSAUX
SYSMAN MGMT_TABLESPACE
MGMT_VIEW MGMT_TABLESPACE
OUTLN SYSTEM
LBACSYS SYSTEM
MDSYS SYSAUX
ORDSYS SYSAUX
ANONYMOUS SYSAUX
EXFSYS SYSAUX
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
WMSYS SYSAUX
XDB SYSAUX
ORDPLUGINS SYSAUX
SI_INFORMTN_SCHEMA SYSAUX
DIP USERS
TSMSYS USERS
我输出到了syn.sql中
SQL> select role from dba_roles where role LIKE 'MGM%';
ROLE
------------------------------
MGMT_USER
SQL> drop role mgmt_user;
Role dropped.
以后gc的admin的密码全部设置为这个
密码oracle123
二。删除gc的安装的相关信息(目录,这里略)
三。重新安装gc软件,并打补丁。
打补丁后的步骤:在错误处的话:
[oracle@pegc source]$ cd ..
[oracle@pegc backup]$ ls
8430622 source
[oracle@pegc backup]$ cd 8*
[oracle@pegc 8430622]$ ls
etc files README.txt
[oracle@pegc 8430622]$ $OMS_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.0
Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /home/oracle/OracleHomes/oms10g
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/OracleHomes/oms10g/oraInst.loc
OPatch version : 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location : /home/oracle/OracleHomes/oms10g/oui
Log file location : /home/oracle/OracleHomes/oms10g/cfgtoollogs/opatch/opatch-2011_Dec_08_10-47-04-CST_Thu.log
ApplySession applying interim patch '8430622' to OH '/home/oracle/OracleHomes/oms10g'
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8430622' for restore. This might take a while...
Backing up files affected by the patch '8430622' for rollback. This might take a while...
Patching component oracle.sysman.top.oms, 10.2.0.1.0...
Updating jar file "/home/oracle/OracleHomes/oms10g/sysman/jlib/emagentSDK.jar" with "/sysman/jlib/emagentSDK.jar/oracle/sysman/eml/sec/util/RootCert.class"
ApplySession adding interim patch '8430622' to inventory
OPatch succeeded.
[oracle@pegc 8430622]$ cd $OMS_HOME
[oracle@pegc oms10g]$ cd opmn
[oracle@pegc opmn]$ ls
bin conf lib logs mesg
[oracle@pegc opmn]$ cd bin
[oracle@pegc bin]$ ./opmnctl stopall
opmnctl: stopping opmn and all managed processes...
[oracle@pegc bin]$ cd ..
[oracle@pegc opmn]$ cd ..
[oracle@pegc oms10g]$ cd bin
[oracle@pegc bin]$ ./emctl secure oms -reset
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root Password :
Enter Agent Registration password :
OPMN processes already stopped... Done.
Securing central oms... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key...
WARNING! An Enterprise Manager Root Key already exists in
the Repository. This operation will replace your Enterprise
Manager Root Key.
All existing Agents that use HTTPS will need to be
reconfigured if you proceed. Do you wish to continue and
overwrite your Root Key
(Y/N) ?
Y
Are you sure ? Reset of the Enterprise Manager Root Key
will mean that you will need to reconfigure each Agent
that is associated with this OMS before they will be
able to upload any data to it. Monitoring of Targets
associated with these Agents will be unavailable until
after they are reconfigured.
(Y/N) ?
Y
Generating Enterprise Manager Root Key (this takes a minute)... Done.
Fetching Root Certificate from the Repository... Done.
Generating Registration Password Verifier in the Repository... Done.
Generating Oracle Wallet Password for Enterprise Manager OMS... Done.
Generating Oracle Wallet for Enterprise Manager OMS... Done.
Generating Oracle Wallet for iAS HTTP Server... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating HTTPS Virtual Host for Enterprise Manager OMS... Done.
Securing central oms... Ended.
[oracle@pegc oms10g]$ cd bin
[oracle@pegc bin]$ ./emctl start oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
opmnctl: opmn started
Starting HTTP Server ...
Starting Oracle Management Server ...
Checking Oracle Management Server Status ...
Oracle Management Server is not functioning because of the following reason:
Unexpected error occurred. Check error and log files.
或:
[oracle@pegc bin]$ ./emctl start oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
opmnctl: opmn is already running
Starting HTTP Server ...
Starting Oracle Management Server ...
Checking Oracle Management Server Status ...
Oracle Management Server is Up.
点击"retry"按钮
备注:第一步非常关键。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/119941/viewspace-721755/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/119941/viewspace-721755/