- 3,724,436 Users
- 2,244,759 Discussions
- 7,851,013 Comments
Forum Stats
Discussions
Categories
- 15 Data
- 362.2K Big Data Appliance
- 6 Data Science
- 2.1K Databases
- 625 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 497 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 422 SQLcl
- 63 SQL Developer Data Modeler
- 185.1K SQL & PL/SQL
- 21.1K SQL Developer
- 2.5K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.7K Development Tools
- 14 DevOps
- 3K QA/Testing
- 339 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 72 Java Community Process
- 2 Java 25
- 12 Java APIs
- 141.2K Java Development Tools
- 9 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 16 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 148 LiveLabs
- 34 Workshops
- 10 Software
- 4 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
How to set the listener in 11g r2 in linux

djgeo
Member Posts: 57
Hi,
can someone guide me on adding a new listener other than the default port in oracle 11g r2 in linux?
I tried editing the tns names.ora and listener.ora files.
My dbca ,oui and netca is not coming up while i try to access them.
Thank you.
can someone guide me on adding a new listener other than the default port in oracle 11g r2 in linux?
I tried editing the tns names.ora and listener.ora files.
My dbca ,oui and netca is not coming up while i try to access them.
Thank you.
Tagged:
Answers
-
cd $ORACLE_HOME/network/admin
fire up your favorit editor like viand create two configuration files:
first one: sqlnet.ora# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
second one: listener.ora Edit your host name here!# listener.ora Network Configuration File: /your_oracle_home_full_path_would_be_here/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <your_server_full_name_or_IP>)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = EPBSD082)(PORT = 8080))(Presentation = HTTP)(Session = RAW) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = EPBSD082)(PORT = 2100))(Presentation = FTP)(Session = RAW) ) )
ans start up your listener.lsnrctl start
you have to setup your oracle shell variables for this!
I do it with this way(using oracle oraenv script)
I added these lines into my .bash_profileecho "Setting enviroment for MYDB as default" export ORACLE_SID=MYDB export ORAENV_ASK=NO . oraenv export ORACLE_UNQNAME=$ORACLE_SID export ORAENV_ASK=YES export NLS_LANG=AMERICAN_AMERICA.UTF8
this will setup
ORACLE_BASE, ORACLE_HOME, ORACLE_SID, ORACLE_UNQNAME, ORAENV_ASK, LD_LIBRARY_PATH and PATH (will add ORACLE_HOME/bin into it so you can run lsnrctl from any dir...) -
BTW if you setup a vnc server and log in to it you may able to run all the tools you mentioned...
-
when i try to acess the dbca,oui and netca...nothing is coming up.Is it an issue with the database installation?
but the installation of the database was successfull and i could connect to the database.But when i give lsnrctl it shows an error.
TNS-12545- TNS:NO LISTENER
TNS-12560- TNS:PROTOCOL ADAPTER ERROR
TNS-00515- NO LISTENER -
user9336763 wrote:Why? One default listener, on one default port, is quite capable of servicing multiple database instances of multiple versions running from multiple homes.
Hi,
can someone guide me on adding a new listener other than the default port in oracle 11g r2 in linux?
>I tried editing the tns names.ora and listener.ora files.The listener doesn't care about tnsnames.oraMy dbca ,oui and netca is not coming up while i try to access them.So exactly what DOES happen? These are gui tools, so on *nix you'll need to export your DISPLAY variable to an x-server.Thank you. -
Did you setup your oracle shell variables as I advice to do so?
Please give us more info what did you try and how. -
Kindly paste your /etc/hosts and $ORACLE_HOME/network/admin/listener.ora file
-
when i installed oracle 11g in linux,towards the end of the install i got an error msg:
"Enterprise manager configuration failed due to the following error:
The 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." -
start netca as oracle
cd $ORACLE_HOME/bin
./netca --> you need a x-window
and create a listener then start it with "lsnrctl start"
check the status with lsnrctl status
This discussion has been closed.