Enable Database Enterprise Manager Console on Oracle EBS R12.1.1

I’m yet to check this one out. Reblogging to avoid losing the link among the ocean of bookmarks those I already have.

Joey Out Of The Box

First login as applmgr user, shutdown all application tier process using .
Login as oracle user to linux. Source the database environment.
Ensureis set in the init.ora for the
database using this command:

SQL> show parameter
REMOTE_LOGIN_PASSWORDFILE;

Create a password file using this command on linux:

Then execute this command:

(remember to change SID and port if needed).
You will be asked some question:

SYSMAN schema will be dropped and recreated.
While dropping the scema, database will be quisced.
Database sessions that blocking the quiescing process must be killed.
Use sqlplus to identify the sessions:

Make note on SID and SERIAL#.
Kill the session using this sql command:

(don’t forget to change SID and SERIAL#).
On create schema process you may need to increase the size of SYSAUX tablespace.
After the process completed you can access the enterprise manager on internet browser using this URL:

You may also have…

View original post 18 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.