Networking And Gateways :: Listener Error - Failed To Start

Sep 23, 2011

after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

Listener failed to start. See the error message(s) above...

View 16 Replies


ADVERTISEMENT

Networking And Gateways :: Listener Start Failed After Configuring?

Nov 2, 2011

i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).

Steps :

1) i installed Oracle 11g R2 Software Only.

2) Started DBCA to configure Database

3) I got a message that i need to configure Listener first.

4) I opened NETCA and add a listener ( default name LISTENER)

5) Then re-opened DBCA to start Database configuration and found the same message configure listner.

6) I went to control panel-> Services -> i found no listeners there

7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener

9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error

10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :

Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.

[code]....

View 4 Replies View Related

Networking And Gateways :: Unable To Start Listener

Mar 1, 2011

I am having a problem getting my listener to start.

[oracle@jhlinux ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))
[code]...

View 36 Replies View Related

Networking And Gateways :: Unable To Start Listener?

Feb 27, 2011

I could not able to start the listener if i have named it other than the default name: LISTENER and the default Port:1521

if I name it list and port : 9999 it is throwing an error as

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 13:02:23

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora
Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml
TNS-01151: Missing listener name, list, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

Should i have to do some changes in sqlnet.ora for overriding the default settings?

View 17 Replies View Related

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.

I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".

I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.

All the services except the listener started up. Attempting to start the listener caused the following error:

"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.

View 2 Replies View Related

Networking And Gateways :: Can't Resolve Tns 12541 Error - No Listener

Nov 1, 2010

My database link to the remote database used to work fine until the company VPN was updated for some security reasons. Now When I try to connect using the DBlink now, error comes up:

TNS 12541 no listener.

Checked the actual listener on the remote database(destination) and it is up and running fine. I am able to ping their machine.

ping <remote host> -works fine
tnsping<remte host> -fails

it comes back with error
TNS 12541: no listener

Nothing has been changed on both databases. The destination database can connect to our database without any issues(they can tnsping and use the dblinks to our database).

LISTENER ENTRY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
[Code] ......

None of the above should be the cause because there was no change been made on any of these.

View 3 Replies View Related

Networking And Gateways :: Any Option To Change Default Listener As Listener 1

Mar 11, 2010

I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.

also,everytime when i give lsnrctl>show current_listener it is showing "listener"

i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.

View 8 Replies View Related

Networking And Gateways :: Add SID In Listener.ora File To Reload Listener?

Jul 5, 2010

In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?

As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.

View 4 Replies View Related

ORA-12500 / TNS - Listener Failed To Start A Dedicated Server Process

Dec 12, 2011

We are getting the below error in between from database. The database throws the below error some times only not continuous.

ORA-12500, TNS:listener failed to start a dedicated server process.

View 6 Replies View Related

Networking And Gateways :: Start Multiple Listeners In One Oracle Database?

Dec 6, 2011

can i start multiple listeners in one oracle database ?

View 7 Replies View Related

Networking And Gateways :: Ora-12546 Tns Permission Failed?

Feb 15, 2010

I am installing Oracle 10g using windows 7 but i am facing problem Ora-12546.

View 6 Replies View Related

Networking And Gateways :: TNS-03505 / Failed To Resolve Name

May 21, 2012

I have 2 virtual machines, in that two vitual machines oracle servers are there.

machine 1 environment file (ofdb.env):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=ofdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

[code]....

machine 2 environment file (.bash_profile):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID

[code]....

Now i want to connect from "DB11G (client)" to "ofdb (server)"

ofdb (TNSNAMES.ora) :

TO_OFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))

[code]....

DB11G (listener.ora) :

ofdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

in both server & client i had set "TNS_ADMIN = $HOME" (see the above environment files) so,

my listener file is in server home directory

my tnsname file is in client home directory

i was started listener in server (ofdb):

$ lsnrctl start ofdb

listner started successfully then came to client side (DB11G) :

$ tnsping TO_OFDB

"TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 21-MAY-2012 10:11:27

Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name"

View 9 Replies View Related

Networking And Gateways :: Oracle Net Services Configuration Failed

Jul 10, 2008

when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca

java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)

Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..

View 2 Replies View Related

Networking And Gateways :: Clients Connections Failed Intermittently?

Jul 16, 2012

have some problem between my database and the listener Sometimes I have connection errors: The error occurred intermittently

Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =

[code]...

The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: .

[code]...

But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start

[code]....

View 2 Replies View Related

Networking And Gateways :: Listener Dynamic Registration

Jan 3, 2012

Which parameters are required in init file for 'Dynamic Listener Registration'? (for default port/ protocol). I understand that Local_listener is required only if we are using not default protocol, port.

Also which cases we need listener.ora file? I understand we need it for 'Duplicate Database' using RMAN as well as for 'Data Guard'. what else will need it?

View 4 Replies View Related

Networking And Gateways :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Networking And Gateways :: Listener Could Not Listen Ora 11 XE Server

Mar 10, 2012

I have installed on my local machine the Ora 11 XE server and the client. Its okay. I can logon from the OAS normally.

However, when I try to connect from my Php application, the messages that comes is: 'ORA-12154: TNS:could not resolve service name'.

View 9 Replies View Related

Networking And Gateways :: How To Find Out The Listener Password

Mar 24, 2011

How to find out the listener password in oracle?

View 3 Replies View Related

Networking And Gateways :: Configure Listener Using Net Manager

Oct 29, 2011

When i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".

View 7 Replies View Related

Networking And Gateways :: Listener For Oracle HS Not Starting?

Mar 16, 2011

I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.

-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1

[code]..

Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=

[code]...

View 1 Replies View Related

Networking And Gateways :: Listener Hangs After Starting Up

Apr 28, 2011

I just installed oracle 11g on a fresh RHEL 5.2 installation on virtual box.

The database is up, but the listener (LISTENER) hangs after a minute from starting it, and then any lsnrctl command just hangs without showing any error messages, when I restart the virtual machine and then start the DB and listener, it works for a minute and it hangs again!

View 2 Replies View Related

Networking And Gateways :: Bind 1 Listener On 2 Interfaces?

Nov 5, 2010

Is it possible to bind an Oracle Listener on 2 different interfaces on the same host?

My initial situation: I've set up a new VLAN in eth1.8 on our database server. There are 2 Oracle instances on this host. One instance was set up for the new VLAN, this works fine. The other listener stayed in the old network, because an other customer also needs to access this instance.

Now the customer wo was set up for 2 new VLAN can't access the other instance listenig on the interface eth0.

In short I have the following setup:
customer1: eth0
customer2: eth1.8 (VLAN)

listener1: LST1
listener2: LST2

SSID1: SID1
SSID2: SID2

listener1 is listening on eth0 for SID1
listener2 is listening on eth1.8 for SID2
This works fine.

Now customer2 needs to access SID1, which is configured on eth0, but customer2 is configured for eth1.8

So I need a listener for SID2, that is configured for both interfaces eth0 AND eth1.8.

View 12 Replies View Related

Networking And Gateways :: Listener Support No Services

Jan 24, 2012

i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 24-JAN-2012 13:45:44
Uptime 0 days 0 hr. 3 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....

now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr

View 14 Replies View Related

Networking And Gateways :: Can't Connect To Remote DB Listener

Jul 2, 2010

I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).

I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).

Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.

View 31 Replies View Related

Networking And Gateways :: ORA-12518 Tns - Listener Does Not Currently Know Of Service?

Jan 31, 2013

ORA-12518 Tns: Listener does not currently know of service

from application server using client 10g to connect our database.This problem happens only in application server and we tried from another server we can connect to database easily but problem only in application server.

this error since TNSNAMES and network are properly hosted since there no network disconnection betwwen database server and application server.

View 1 Replies View Related

Networking And Gateways :: Listener Configured At Non-Default Port?

May 16, 2011

I have configured oracle listener at Non-Default port 1526.

Is it mandatory to mention LOCAL_LISTENER parameter at pfile?

LOCAL_LISTENER='listenerr_alias'

View 2 Replies View Related

Networking And Gateways :: Resetting Password For Listener Inherit?

Dec 7, 2010

I just found out that the LISTENER I've creating with a password was with "-inherit" settings. Twice I succeeded in doing this, but it seems that it's not working when I tested it. Thus, I opted to get rid of it's listener.bak file and set the password again. Now I just can't stop it because of this error message: "TNS-01169: The listener has not recognized the password".

I've tried every passwords I made, and tried resetting it, but I'm not successful either, it's the same error message.My last option would be to restart the db Server (since the original listener.ora is already intact),

View 7 Replies View Related

Networking And Gateways :: Multiple Home Listener Configuration?

Jul 29, 2011

I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.

View 7 Replies View Related

Networking And Gateways :: Listener PSWD Authentication On Windows XP

Nov 21, 2010

I have set password on the listener and set the local_os_authentication parameter to "OFF", whenever i start/stop listener through "lsnrctl" ,it works fine and asks for password but i can stop/start listener through windows services without giving any password.

what is the use of setting password on listener if any body can start/stop it through services utility in windows xp sp3.

View 5 Replies View Related

Networking And Gateways :: ORA-12514 / TNS / Listener Could Not Resolve SERVICE_NAME

Apr 22, 2011

I have a database named DBKNIT and my server name is USMSERVER, But i cant login to the PLSQL from my client PC , there is an error :

ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved