Re: [Q] how to manually create sysman on database to use dbconsole on 10gr2?

Hi here is an example
connect SYS/***@PERP as SYSDBA
set echo off
spool C:\emRepositoryPERP.log
@D:\oracle\product\10.2.0\db_1\sysman\admin\emdrep\sql\emreposcre D:\oracle\product\10.2.0\db_1 SYSMAN SYSMANpass TBL_TEMP ON; WHENEVER SQLERROR CONTINUE;
spool off

to create console

D:\oracle\product\10.2.0\db_1\bin\emca.bat -config dbcontrol db -silent -DB_UNIQUE_NAME PERP -PORT 1522 -EM_HOME D:\oracle\product\10.2.0\db_1 -LISTENER LISTENER -SERVICE_NAME PERP -SYS_PWD *** -SID PERP -ORACLE_HOME D:\oracle\product\10.2.0\db_1 -DBSNMP_PWD DBSNMPASS -HOST SRVDAZ07 -LISTENER_OH D:\oracle\product\10.2.0\db_1 -LOG_FILE C:\emConfigPERP.log -EMAIL_ADDRESS jreyes_at_dazasoftware.com -MAIL_SERVER_NAME mail.dazasoftware.com -SYSMAN_PWD SYSMANPASS

>

-- 
----------------------------------------
http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

--
http://www.freelists.org/webpage/oracle-l