Dbd Error Ociserverattach Ora-12541
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) Want to Advertise Here? Solved ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) Posted on 2009-04-29 Oracle Database 1 Verified Solution 2 Comments 8,740 Views Last Modified: 2013-12-18 This is the below error in Oracle 10g Enterprise manager ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach). I had started listner, and enterprise manager using emctl start dbconsole, everything went fine, but i am getting the above error in the Enterprise manager page. Kindly advise me to rectify the above error 0 Question by:umesh4exp Facebook Twitter LinkedIn Google LVL 68 Active 2 days ago Best Solution bywoolmilkporc Also check the ConnectDescriptor in ${ORACLE_HOME}/${HOSTNAME}_${ORACLE_
listener (DB Options ISMAIL View Member Profile Dec 27 2008, 06:25 AM Post #1 Newbie Group: Members Posts: 1 Joined: 27-December 08 Member No.: 39,268 Dear AllI have two instances on racNMH.newsource.com_NMH1 30 1 8 +ASM1_nmhdb001.newsource.com NMH.newsource.com_NMH2 the second Instance it gave critical https://www.experts-exchange.com/questions/24364847/ORA-12541-TNS-no-listener-DBD-ERROR-OCIServerAttach.html error that Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).then that details giving asI got Critical Error in OEM that Jun 30, 2008 9:20:17 AM Agent is Unreachable (REASON = Connection refused) but the host is UP I tried to start listener http://dbaforums.org/oracle/index.php?showtopic=17139 but it said LSNRCTL> start LISTENER_nmhdb002TNS-01106: Listener using listener name LISTENER_nmhdb002 has already been started then status saysLSNRCTL> listener_nmhdb002 statusNL-00853: undefined command "listener_nmhdb002". Try "help"LSNRCTL> STATUSConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nmhdb002-vip)(PORT=1521)(IP=FIRST))STATUS of the LISTENER------------------------Alias LISTENER_nmhdb002Version TNSLSNR for Solaris: Version 10.2.0.2.0 - ProductionStart Date 30-JUN-2008 09:24:14Uptime 91 days 3 hr. 57 min. 4 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/oracle/oracle/product/10.2.0/db/network/admin/listener.oraListener Log File /u01/oracle/oracle/product/10.2.0/db/network/log/listener_nmhdb.logListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.212)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.205)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Services Summary...Service "+ASM" has 1 instance(s). Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...Service "+ASM_XPT" has 1 instance(s). Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...Service "NMH.newsource.com" has 2 instance(s). Instance "NMH1", status READY, has 1 handler(s) for this service... Instance "NMH2", status READY, has 2 handler(s) for this service...Service "NMHXDB.newsource.com" has 2 instance(s). Instance "NMH1", status READY, has 1 handler(s) for thi
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm
ORA-12541: TNS: no listener Oracle Tips by John Garmany You Asked: I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener also. I have no problems accessing the database through SQL*Plus. I've checked the listener.ora and tnsnames.ora files and everything seems okay. We Said: From the docs: ORA-12541: dbd error TNS no listener Cause: Listener for the source repository has not been started. Action: Start the Listener on the machine where the source repository resides. Basically the Forms server could not find the listener. First check the tnsnames.ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. dbd error ociserverattach Finally, check the listener. First, ensure that your listener service is running. C:\Documents and Settings\ME>lsnrctl stat This should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry.Try to start the listener service using lsnrctl from DOS prompt. set ORACLE_HOME= cd %ORACLE_HOME%/bin lsnrctl start LISTENER If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command: C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener. If you are on Windows, also verify that the listener service is running. Here are more notes on lsnrctl: Oracle listener lsnrctl command Oracle listener lsnrctl command Oracle listener security tips Blocking Oracle access by IP Addresses �� Burleson is the