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...are your sure there is no listener file in 11g home?
# listener.ora Network Configuration File: e:\app\aaa\product\11.2.0\dbhome_1\network\admin\listener.oracheck
lsnrctl status
see if you 11g database service is registered.
is tnsping working fine?
their is listener file in 11g home, and I have given the content of it... but when I checked the services using services.msc their is only services for 9i and 10g no for 11g...
Member Posts: 189
edited September 2012
The part of the content of the Installaction log file
INFO: Oracle Net Services Configuration:
INFO: Profile configuration complete.
INFO: Oracle Net Listener Startup:
INFO: The information provided for this listener is currently in use by other software on this computer.
INFO: Listener start failed.
INFO: Check the trace file for details: e:\app\amjadali\cfgtoollogs\netca\trace_OraDb11g_home1-12093010PM0833.log
INFO: Oracle Net Services configuration failed. The exit code is 1
INFO:
WARNING:
INFO: Completed Plugin named: Oracle Net Configuration Assistant
INFO: Oracle Net Configuration Assistant failed.
INFO: Oracle Net Configuration Assistant failed.
the result of lsnctrl status is
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-SEP-2012 23:33
:27
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 30-SEP-2012 21:20:29
Uptime 0 days 2 hr. 12 min. 58 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File d:\oracle\ora92\network\admin\listener.ora
Listener Log File d:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aaa)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aaa)(PORT=8080))(Presentation=HTTP
)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aaa)(PORT=2100))(Presentation=FTP)
(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "old" has 2 instance(s).
Instance "old", status UNKNOWN, has 1 handler(s) for this service...
Instance "old", status READY, has 1 handler(s) for this service...
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
The command completed successfully
Edited by: AAP on Sep 30, 2012 11:13 AM
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-SEP-2012 23:33
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
Listener Parameter File d:\oracle\ora92\network\admin\listener.ora
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aaa)(PORT=1521)))export ORACLE_SID,ORACLE_HOME and start the listener and let us know the o/p
export ORACLE_SID=YOUR_INSTANCE_NAME
export ORACLE_HOME=YOUR_11G_ORACLE_HOME_PATH
lsnrctl start
lsnrctl status
tnsping YOUR_NET_SERVICE_NAME_of_11g
Member Posts: 189
edited September 2012
sorry I didnt got this , can you give me e.g. of this tnsping YOUR_NET_SERVICE_NAME_of_11g
do you mean by this ...
C:\Documents and Settings\aaa>tnsping new
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2
012 00:16:05
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
e:\app\aaa\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = new)))
OK (30 msec)
C:\Documents and Settings\aaa>
rest is below
C:\Documents and Settings\aaa>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:11
:24
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
C:\Documents and Settings\aaa>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:11
:41
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 30-SEP-2012 21:20:29
Uptime 0 days 2 hr. 51 min. 12 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File d:\oracle\ora92\network\admin\listener.ora
Listener Log File d:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=8080))(Presentation=HTTP
)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=2100))(Presentation=FTP)
(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "old" has 2 instance(s).
Instance "old", status UNKNOWN, has 1 handler(s) for this service...
Instance "old", status READY, has 1 handler(s) for this service...
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
The command completed successfully
Edited by: AAP on Sep 30, 2012 11:44 AM
Edited by: AAP on Sep 30, 2012 11:47 AM
Edited by: AAP on Sep 30, 2012 11:47 AM
Member Posts: 407
edited September 2012
In your e:\app\aaa\product\11.2.0\dbhome_1\network\admin\listener.ora file
change listener name to listener_11g and port 1521 to 1621 and start the 11g listener with lsnrctl start listener_11g and lsnrctl status listener_11g. Is your 11g database name is new or CLRExtProc. Make sure your 11g database entry is located in tnsnames.ora of 11g home.
LISTENER*_11g* =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = *1621*))
)
)
AAP wrote:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))You need to decide what is hostname; "localhost" or "amjad" and use same hostname everywhere.
BTW, when hostname=localhost; then not remote client can ever connect to this listener, DB or server
Thanks for reply
my database name is new , should i use somewhere for correction... along with ur above suggestion...
AAP wrote:
Thanks for reply
my database name is new , should i use somewhere for correction... along with ur above suggestion...lsnrctl stop
move, remove, rename e:\app\aaa\product\11.2.0\dbhome_1\network\admin\listener.ora file to a different name
listener.ora file is NOT need to start the listener, then do as below
lsnrctl start
lsnrctl status
REM - wait more than 60 seconds then continue below
lsnrctl service
COPY command & results from above then PASTE all back here
C:\Documents and Settings\amjadali>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:35
:41
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service , error 1060.
TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.xm
l
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-OCT-2012 00:35:46
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
The listener supports no services
The command completed successfully
C:\Documents and Settings\amjadali>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:36
:10
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-OCT-2012 00:35:46
Uptime 0 days 0 hr. 0 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=8080))(Presentation=HTTP
)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=2100))(Presentation=FTP)
(Session=RAW))
Services Summary...
Service "old" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Documents and Settings\amjadali>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:37
:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "old" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1054))
The command completed successfully
C:\Documents and Settings\amjadali>
AAP wrote:
C:\Documents and Settings\amjadali>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:35
:41
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service , error 1060.
TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.xm
l
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-OCT-2012 00:35:46
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
The listener supports no services
The command completed successfully
C:\Documents and Settings\amjadali>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:36
:10
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-OCT-2012 00:35:46
Uptime 0 days 0 hr. 0 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=8080))(Presentation=HTTP
)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=2100))(Presentation=FTP)
(Session=RAW))
Services Summary...
Service "old" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Documents and Settings\amjadali>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:37
:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "old" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "oldXDB" has 1 instance(s).
Instance "old", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1054))
The command completed successfully
C:\Documents and Settings\amjadali>add line like below to the tnsnames.ora file
FOOBAR=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AMJAD)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OLD)))
then open command window & issue command below
sqlplus scott/[email protected]
COPY results from above then PASTE all back here along with complete content of tnsnames.ora file
Member Posts: 407
edited September 2012
perfect............all you need to do now is register your database with the listener.
you can use netca for that or manually register it in listener.ora by including below lines.
in your 11g listener.ora file replace below one
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")
)
)
with similar like below one.
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")
)
(SID_DESC =
(ORACLE_HOME = e:\app\aaa\product\11.2.0\dbhome_1)
(SID_NAME = new)
)
)
I recommend you to use netca so that you wont end up with syntax errors.
Veeresh.S wrote:
perfect............all you need to do now is register your database with the listener.
you can use netca for that or manually register it in listener.ora by including below lines.DB is already registered. See Below
Service "old" has 1 instance(s).
I am getting this error after this command
C:\Documents and Settings\amjadali>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 00:54
:15
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is e:\app\amjadali\product\11.2.0\dbhome_1\network\admin\l
istener.ora
Log messages written to e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.xm
l
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string
Listener failed to start. See the error message(s) above...
C:\Documents and Settings\amjadali>
Content of my listener.ora file is
# listener.ora Network Configuration File: e:\app\amjadali\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\amjadali\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:e:\app\amjadali\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(ORACLE_HOME = e:\app\amjadali\product\11.2.0\dbhome_1)
(SID_NAME = new)
)
)
LISTENER_11g =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1621))
)
)
ADR_BASE_LISTENER = e:\app\amjadali
old is the name of database which i created using oracle 9i
11g database name is new
Is the oracle mixing all my listener file as I am having all 9i, 10g and 11g install on the same pc but I have installed on different drives...
Member Posts: 407
edited September 2012
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amjad)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV stringthat's why I told you to use netca or netmgr.
let the listener.ora be how it was before so undo the changes and start the listener it should start without errors.
then open net manager(netmgr) and manually register your database "NEW" and open net configuration assistant(netca) and add tns service name for your database and try
lsnrctl status ----should show the "new" database service.
tnsping new
sqlplus sys/[email protected] as sysdba
Member Posts: 189
edited September 2012
I have done what you said ,,
C:\Documents and Settings\amjadali>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-OCT-2012 01:17
:06
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 01-OCT-2012 01:13:19
Uptime 0 days 0 hr. 3 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File e:\app\amjadali\product\11.2.0\dbhome_1\network\admin\
listener.ora
Listener Log File e:\app\amjadali\diag\tnslsnr\amjad\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Documents and Settings\amjadali>
But sorry the rest step i dont know how to put in netmgr and net configuration assistant please can you help me in the steps
In Oracle Net Manager , below the service naming the name of database is coming...
Edited by: AAP on Sep 30, 2012 12:53 PM
Member Posts: 407
edited September 2012
try adding the value manually, give a last try
in your listener.ora file
Replace
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = e:\app\amjadali\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:e:\app\amjadali\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
with
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=new)
(ORACLE_HOME=e:\app\amjadali\product\11.2.0\dbhome_1)
)
)
and in your 11g tnsnames.ora add below lines
new_db_tns =
(description =
(address_list =
(address =
(protocol = tcp)
(host = 127.0.0.1)
(port = 1521)
)
)
(connect_data =
(sid = new)
)
)
then try
tnsping new_db_tns
sqlplus sys/[email protected]_db_tns as sysdba
if you got any errors post listener.ora and tnsnames.ora of 11g home.
I will try what you suggested....
In the mean time I had created one more database using DBCA and at the end of creation I am getting the same error which I got when creating a database at the time of installing Oracle 11g...
Database Configuration Assistant Warning
Enterprise Manager configuration failed due to the following error 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 ,,,,,,,
you can retry configuring this database with enterprise manager later by manually running e:\app\,,,,\dbhome\bin\emca script
The error message explains it all...................
create a database, create a listener(net manager), register a database(net manager), add tns entry(net configuration assistant) then configure the EM using dbca or manually using emca.
this is how you should follow....
follow my last post and see if you can connect
I have created 2 Database new and newdb using 11g , able to connect from sql prompt... but not able to start enterprise manager... infact option not coming at all...
The Content of Listener.ora_
# listener.ora Network Configuration File: e:\app\amjadali\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\amjadali\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:e:\app\amjadali\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\amjadali
The Content of Tnsnames.ora_
# tnsnames.ora Network Configuration File: e:\app\amjadali\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
NEWDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = newdb)
)
)
LISTENER_NEW =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_NEWDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
NEW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = new)
)
)
if you can conn to your database through net service name then you can proceed with the creation of EM for your database.
There are 2 methods
a>emca --manually
b>dbca --GUI
b>using dbca (http://docs.oracle.com/cd/E18283_01/server.112/e17120/dbcontrol002.htm)
open dbca
select Configure Database Options.
select the database you want to configure.
Advance to the Management Options page (Figure 1-4) and select the following options:
Configure the Database with Enterprise Manager
Use Database Control for Database Management
Optionally, select the options for enabling email notifications and enabling daily backups.
Advance until the Finish button is available.
Click Finish to reconfigure the database so it uses Database Control.
a>using emca(http://www.akadia.com/services/ora_dbconsole.html)
set oracle_sid
set oracle_home
emca -repos create
emca -config dbcontrol db
Member Posts: 189
I tried the First option... but at the end I got the following message
Configuration Assistant : Warning
Configuring Database with database control requires a listener tp be configured in the current oracle home.
you need to run netca to configure a listener before you can proceed. otherwise you choose to continue without database control configuration... ok
Member Posts: 27,955 Gold Crown
edited October 2012
AAP wrote:
I tried the First option... but at the end I got the following message
Configuration Assistant : Warning
Configuring Database with database control requires a listener tp be configured in the current oracle home.
you need to run netca to configure a listener before you can proceed. otherwise you choose to continue without database control configuration... okThe messages look pretty self explanatory ....
The creation of the dbcontrol requires a connection via the listener. So the listener must already know about the database, either through a static or a dynamic registration. And given that some operations you can do with dbcontrol involve starting/stopping the db, you really can't relay on dynamic registration .... so make sure the db is listed in the SID_LIST section of the listener.ora file.
Edited by: EdStevens on Oct 1, 2012 7:04 AM
Edited by: EdStevens on Oct 1, 2012 7:06 AM