The Oracle Net Listener is a service listening for incoming database connection request.

learn more… | top users | synonyms

1
vote
1answer
63 views

How does SQL*Plus connect to Oracle without a listener?

sqlplus can be used even if there is no listener in the system, or if it isn't running. How does SQL*Plus connect to Oracle without a listener?
0
votes
0answers
25 views

Enable Oracle network encryption

I have to enable network encryption on a specific instance. We have a single DB machine runnning one listener from /etc/listener.ora and several instances. TNS_ADMIN is set to /etc. Oracle 11.2g is ...
0
votes
1answer
67 views

listener can not start

My listener in oracle 11GR2 can not start . when i want to give the status of that , the error in below is shown : Connecting to > TNS-12541 : TNS:no listener TNS-12560 : TNS:protocol adapter error ...
0
votes
2answers
108 views

Listener Log Oracle 11g R2

I'm using Oracle 11gR2 in RHEL5. Now a days my application, during run time, is showing exception as below. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate ...
0
votes
2answers
170 views

Cannot connect to database remotely (not even locally when using ip address)

I can login using this command: sqlplus test/test@127.0.0.1:1521/local But not this one: (where 192.168.0.240) is my IP sqlplus test/test@192.168.0.240:1521/local I am absolutely sure that my ip ...
0
votes
1answer
237 views

Unable to create a new listener in oracle 11g

In net manager i get an error message "A valid logfile is required" when i click on listener and choose '+' button. and then it keeps on giving me that error when i click on any other tab or button in ...
0
votes
1answer
285 views

extproc env variables oracle 11g

I have oracle 11g with extproc separately configured in listener.ora. Users report some environmental variables that should be exported are not set. From where does extproc gets it environment ...
1
vote
0answers
2k views

Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant

this is my first time to install Oracle 11g R2 on Linux. I made all instructions in Oracle documentation. But in the installation process, the Net Configuration Manager is failed. I continued the ...
4
votes
1answer
12k views

Oracle 11g listener fails with ORA-12514 and ORA-12505 errors

I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus: c:\>sqlplus ace SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
1
vote
1answer
734 views

listener does not currently know of SID given in connect descriptor in oracle 10g and solaris 10 env

I have a oracle 10g database in solaris 10 system. The SID=OTRS, I can connect to oracle database from local server itself. But I can not able connect from another client. It is returning an error ...
0
votes
1answer
2k views

check listener status other than 1521

I have two listner: one is running on port 1521 another on 1531. lsnrctl stat show's status of services running on port 1521 only. How should i check whether the services running on port 1531 is ...
1
vote
1answer
3k views

User can't stop Oracle listener (TNS-01190)

I have Oracle 10g installed on RedHat Enterprise Linux 5. I have 2 users that use Oracle: uid=501(user1) gid=502(group1) groupes=500(oinstall),501(dba),502(group1) and uid=500(oracle) ...
0
votes
1answer
2k views

Oracle 10g Listener problem

In Oracle 10g I have a listener problem, Here is tnsnames.ora : MYTNS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = testiold) (PORT = 1521) ...
1
vote
1answer
2k views

Oracle server connection reset by peer socket write error

Full disclosure, I'm not a database admin, but if anyone is able to help me, it would be you guys. Our Oracle 11g database server stopped working, I'm not aware of anything that could have caused it, ...
0
votes
1answer
936 views

Override default SERVICE_NAME in init.ora

I'd like to define several service names for my instance in such a way that users should not know the actual instance name. This is what I have done in my init.ora: db_domain='company.com' ...
1
vote
2answers
12k views

ORA-01034: ORACLE not available

I tried to start the listener and do a dbstart, but it looks like it is still saying "Oracle Not available". Maybe the dbstart didn't work. Any suggestions would help me. [user@fedora16 bin]$ echo ...
3
votes
2answers
12k views

Error ORA-12541: TNS:no listener

Whenever I try to start the listener (I just have only one Oracle database) I get the following: LSNRCTL> status Connecting to ...
2
votes
1answer
9k views

SQL Developer cannot connect to Oracle database, yet sqlplus can!

I am having a problem connecting sql developer to my Oracle 10g database. sqlplus is able to connect fine, but when I try to open the connection in sql developer, I get 'ORA-12514 TNS does not know ...
7
votes
2answers
23k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

I have access to a ORACLE 11g server using the following listener.ora # listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by ...