configure the dbase using em in oracle 11g
TRANSCRIPT
Dr.GIRIJA NARASIMHAN 1
CONFIGURE THE DATABASE USING
ENTERPRISE MANAGER IN ORACLE 11G
Dr.GIRIJA NARASIMHAN 2
step 1: Always OracleTNSListener, Orcl (i.e database) to be restarted--> it should be in "started" mode step2: configure the database program-->oracle-oradb11g_home1-->configuration and migration tools--> database configuration assistant-->next configuration database options-->next-->(database,username, password)-->next-->database components -->"oracle label security" (select check box)-->next-->dedicated server mode-->finish (this is one time or first time, no need to do always)
Dr.GIRIJA NARASIMHAN 3
Dr.GIRIJA NARASIMHAN 4
Dr.GIRIJA NARASIMHAN 5
Dr.GIRIJA NARASIMHAN 6
Username sys password oracle
Dr.GIRIJA NARASIMHAN 7
Dr.GIRIJA NARASIMHAN 8
Dr.GIRIJA NARASIMHAN 9
Dr.GIRIJA NARASIMHAN 10
Creating environment variables
Dr.GIRIJA NARASIMHAN 11
My computer mouse right click properties
Dr.GIRIJA NARASIMHAN 12
System properties advanced
Dr.GIRIJA NARASIMHAN 13
Advanced environment variables
Dr.GIRIJA NARASIMHAN 14
Click new new user variable appear type “oracle_home” in
variable name (you can type any name) type variable value
“e:\app\user\product\11.2.0\dbhome_1
(oracle home directory path)