This content has been marked as final. Show 8 replies
fire up your favorit editor like vi :) and create two configuration files:
first one: sqlnet.ora
second one: listener.ora Edit your host name here!
# 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)
ans start up your listener.
# 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) ) )
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_profile
this will setup
echo "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
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...1 person found this helpful
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.
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.ora
My 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.
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
./netca --> you need a x-window
and create a listener then start it with "lsnrctl start"
check the status with lsnrctl status