Oracle Database Discussions

Hi all,

I had installed 9i, 10g on Windows xp sp3, and they both are working fine from last few months, I had installed them on different drive,
Now When I tried to install 11g r2 on the same machine on another different drive at the end I got... the following error and I am not getting option nowhere to start from enterprise manager , however the database *( the name of the database is new )* has been created and I am able to all the things from command prompt.
The First Error I got is.

Oracle Net configuration failed, and when I retry it.. it showed successful

this are few lines when I checked the emConfig.log file

ONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1001)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:346)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
Sep 30, 2012 10:13:45 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at e:\app\amjadali\cfgtoollogs\dbca\new\emConfig.log for more details.
Sep 30, 2012 10:13:45 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

Content of the Listener.ora file... and I have checked the services... their is a listener file for 9i and 10g but no listener file for 11g...

# listener.ora Network Configuration File: e:\app\aaa\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = e:\app\aaa\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:e:\app\aaa\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = e:\app\aaa


Thanks and Regards

Edited by: AAP on Sep 30, 2012 10:44 AM

Edited by: AAP on Sep 30, 2012 10:48 AM