Tuesday, January 6, 2009

Enable Enterprise Manager on the Oracle E-Business Suite Release 12

- Keep the database and listener running. It is not necessary that any other Application services to be running for this process to complete.

- As the owner of the 10gR2 ORACLE_HOME, run the following command to create the Enterprise Manager repository:

$ emca -config dbcontrol db -repos create

When the command is run, EMCA prompts for the following values

Database SID: OBAIND
Listener port number: 1617
Password for SYS user: xxxxxxxxxx
Password for DBSNMP user: xxxxxxxxxx
Password for SYSMAN user: xxxxxxxxxx
Email address for notifications (optional):Outgoing Mail (SMTP) server for notifications (optional):
- Enter the values

- EMCA shows a summary of the entered values

—————————————————————–
You have specified the following settings

Database ORACLE_HOME ……………. /u11/oracle/OBAIND/db/tech_st/10.2.0 Database hostname ……………. xxxxxxxxx.newgen.com
Listener port number ……………. 1617
Database SID ……………. OBAIND
Email address for notifications ……………Outgoing Mail (SMTP) server for notifications —————————————————————–

Do you wish to continue? [yes(Y)/no(N)]: Y

- Type ‘Y” to start the configuration.
The configuration will take anywhere between 10 to an hour depending on the machine configuration and database size.

Once it gets completes Enterprise manager can be accessed from the URL

http://localhost.domain.com:1158/em

1 comment:

diana_ser said...

nice tool. However, I have heard about another program for how do you import information into a sql database, check it out and find out why it is more efficient