I’m yet to check this one out. Reblogging to avoid losing the link among the ocean of bookmarks those I already have.
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
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