RE: [Q] how to manually create sysman on database to use dbconsol e on 10gr2?

From: Khushalani, Vikram Mr AITS (Binary) <vikram.khushalani_at_us.army.mil>
Date: Tue, 25 Jul 2006 14:52:08 -0400
Message-ID: <7DEEA786E76E904B85D4E83DA06626E1A78104@belvb1wo60ai001.nae.ds.army.mil>

You will first need to create the repository. I believe that SYSMAN is created at that time, since the repository's objects are in SYSMAN schema.

So try the following, it will:

Build the AWR Repository (and user SYSMAN); and
Configure the DBConsole, all with one command.

emca -config dbcontrol db -repos create

Note: You will be prompted for the SYS, DBSNMP, and SYSMAN passwords. So you should have the SYS and DBSNMP passwords available. The SYSMAN account it will create for you with the password you provide it. You will also be prompted for the SID and Listener info.

If you want to use e-mail notification (optional) then you will also need the e-mail account and the Outgoing Mail server information.

I have created this under Windows, but the emca command should be generic and should work on LINUX also.

If you run into problems you can always execute

emca -h

Or just

emca

For help and various options.

Vikram.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Monday, July 24, 2006 9:31 PM
To: juancarlosreyesp_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: [Q] how to manually create sysman on database to use dbconsole on 10gr2?

Thanks. But we are LINUX system not Window. Do you know how to do on LINUX? Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:

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 <mailto:jreyes_at_dazasoftware.com>
-MAIL_SERVER_NAME mail.dazasoftware.com <http://mail.dazasoftware.com>
-SYSMAN_PWD SYSMANPASS

--

http://www.oracleboliviaspecialists.com/ <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

How low will we go? Check out Yahoo! Messenger's low PC-to-Phone <http://us.rd.yahoo.com/mail_us/taglines/postman8/*http:/us.rd.yahoo.com/evt =39663/*http:/voice.yahoo.com> call rates.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 25 2006 - 13:52:08 CDT