如下:
1. Start SQL*Plus from the command line by typing:
sqlplus
2. When you are prompted for the connection information, type:
<emrepository>/<emrepository-pwd>@<em-repository>
to connect to the database.
For example:
mynode/[email protected]
since the default repository name is the hostname.
3. Then type:
execute smp_maintenance.reset_sysman();
1. Start SQL*Plus from the command line by typing:
sqlplus
2. When you are prompted for the connection information, type:
<emrepository>/<emrepository-pwd>@<em-repository>
to connect to the database.
For example:
mynode/[email protected]
since the default repository name is the hostname.
3. Then type:
execute smp_maintenance.reset_sysman();
我靠! 老大!
At first , i must say sorry , bcos my english is very poor
and i must say sorry too, bcos my master oracle little
so i can't understand what 's means for <emrepository>/<emrepository-pwd>@<em-repository>
please explain it in detail ~~~~~~~~~~~~~
thX for ever ~~~~~~~~~~~
c:\>sqlplus /nolog
sql>connect sys/password@oracle_server as sysdba;
sql>execute smp_maintenance.reset_sysman();
-----------------------------------------------------
SQL> execute smp_maintenance.reset_sysman();
BEGIN smp_maintenance.reset_sysman(); END; *
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 7 列:
PLS-00201: 必须说明标识符 'SMP_MAINTENANCE.RESET_SYSMAN'
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
确认已经安装oracle enterprise management组件了~(Win2000Pro2+ORACLE8i1.0.6)
但问题依然存在~~
-------------------------
有另外的方法吗?(除重建资料库)
sql>connect sys/password@oracle_server as sysdba;
这一处使用的应该是档案资料的owner的用户,我这里为ome_manager,而且使用的也不一定是sysdba用户,所以应该修定为以下的语句。
sql>connect oem_manager/password@oracle_server;
---------
(写什么?)
情况1、你有dba用户的口令,我这里使用system其口令假设为manager
sqlplus /nolog
sql>conn system/manager@server;
sql>alter user oem_manager identified by 新口令;
情况2、你可以用oracle用户登陆操作系统
svrmgrl>connect internal
svrmgrl>alter user oem_manager identified by 新口令;