Oracle Listener Commands

Listener commants:
· start – Starts the listener with the name specified, otherwise LISTENER will be used. For Windows systems, the listener can also be started and stopped from the Control Panel.
· stop – Stops the listener. For Windows systems, the listener can also be started and stopped from the Control Panel.
· status – Provides status information about the listener, including start date, uptime, and trace level.
· services – Displays each service available, along with the connection history.
· version – Displays the version information of the listener.
· reload – Forces a read of the configuration file in order for new settings to take effect without stopping and starting the listener.
· save_config – Creates a backup of the existing listener.ora file and saves changes to the current version.
· trace – Sets the trace level to one of the following – OFF, USER, ADMIN, or SUPPORT.
· spawn – Spawns a program that runs with an alias in the listener.ora file.
· dbsnmp_start – Starts the DBSNMP subagent.
· dbsnmp_stop – Stops the DBSNMP subagent.
· dbsnmp_status – Displays the status of the DBSNMP subagent.
· change_password – Sets a new password for the listener.
· quit and exit – Exits the utility.
· set – Changes the value of any parameter. Everything that can be shown can be set.
· show – Displays current parameter settings.

Oracle EM configuration

Step 1: Set the SID in the dos prompt and Login to DB using sys user.
Step2: Check the parameter JOB_QUEUE_PROCESSES value in Database the value should be greater then 0.
Alter system set JOB_QUEUE_PROCESSES=1 scope=both or scope=pfile;
Step3: Execute following drop statements
drop user sysman cascade;
drop public synonym SETEMVIEWUSERCONTEXT;
drop role MGMT_USER;
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop user MGMT_VIEW;
Alter user DBSNMP IDENTIFIED BY DBSNMP;

NOTE:
All the dropped objects will be recreated while creating the Repository.
Step4: Unlock the DBSNMP User using the Query
Alter user DBSNMP ACCOUNT UNLOCK;
Step5: Exit SQL Prompt then execute the command
emca -config dbcontrol db -repos create
Configure the required fields properly.
Login as SYSMAN/SYSMAN