Home » RDBMS Server » Networking and Gateways » Problem with Listener in DB10g on Linux (Oracle Databse 10.2 with RHEL 4)
icon13.gif  Problem with Listener in DB10g on Linux [message #282009] Tue, 20 November 2007 06:43 Go to next message
sahiti
Messages: 9
Registered: November 2007
Location: India
Junior Member
Dear Freinds

I have installed Databse 10.2 version of 64 bit on RHEL 4.The installation was successfull and working fine.My problem is only with Automatic startup and shutdown.I have created a file oracle where script is written and palced it in init.ora.

Listener is not automatically getting started when i restart the machiene.It is giving me 12514 error.At present i am doing it manually like this

[oracle@desktop] . oraenv

[oracle@desktop] lsnrctl stop

[oracle@desktop] lsnrctl start

After that its working fine

But please tell me why the problem in automatic startup.

Thanks & Regards
Sahiti
Re: Problem with Listener in DB10g on Linux [message #282012 is a reply to message #282009] Tue, 20 November 2007 06:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It is giving me 12514 error
It is not related to listener services.

and can you post here your startup/shutdown script.
Re: Problem with Listener in DB10g on Linux [message #282019 is a reply to message #282009] Tue, 20 November 2007 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: Problem with Listener in DB10g on Linux [message #282125 is a reply to message #282009] Tue, 20 November 2007 23:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

Listener is not automatically getting started when i restart the machiene


It is/was expected while running database listener will start automatically.
But it is
Oracle Bug. Wrong entry in startup database script, Listener location is hard coded.I raised this one one month ago. This error is made by one indian script writer vikkram or something like that.
Re: Problem with Listener in DB10g on Linux [message #282763 is a reply to message #282009] Fri, 23 November 2007 06:32 Go to previous messageGo to next message
Girija27
Messages: 1
Registered: March 2005
Location: Hyderabad
Junior Member
hi Mohammad,

thanks for the immediate Reply.

here is my script

#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
#ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi

case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
;;
esac

still i am facing the same error
do i need to add some thing for listener starting

please help me
Thanks & Regards
Re: Problem with Listener in DB10g on Linux [message #282770 is a reply to message #282763] Fri, 23 November 2007 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing that starts the listener in your script.
So yes you need to add something.

Regards
Michel
Re: Problem with Listener in DB10g on Linux [message #282829 is a reply to message #282763] Fri, 23 November 2007 23:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://www.google.ae/search?hl=en&q=reboot+oracle&meta=
Re: Problem with Listener in DB10g on Linux [message #315340 is a reply to message #282770] Mon, 21 April 2008 03:52 Go to previous messageGo to next message
sahiti
Messages: 9
Registered: November 2007
Location: India
Junior Member
Dear Michel,

Till now i am strating the services manually evertime.But now i have finish that Autostartup of Database

Can you give the clear steps to start both listener and database automatically

Thanks in advance

Sahiti
Re: Problem with Listener in DB10g on Linux [message #315343 is a reply to message #315340] Mon, 21 April 2008 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you on Windows or Unix?

Regards
Michel
Re: Problem with Listener in DB10g on Linux [message #315385 is a reply to message #282009] Mon, 21 April 2008 06:21 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
I have created a file oracle where script is written and palced it in init.ora.

Why have you placed it in init.ora file
The script should be in /etc/init.d

WIth 10g
DBSTART starts your listener also.
Re: Problem with Listener in DB10g on Linux [message #315389 is a reply to message #282009] Mon, 21 April 2008 06:35 Go to previous messageGo to next message
sahiti
Messages: 9
Registered: November 2007
Location: India
Junior Member
Michel,

I am on Linux OS with 10g database R2.

regards
Re: Problem with Listener in DB10g on Linux [message #315401 is a reply to message #315389] Mon, 21 April 2008 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Add "lsnrctl start <listener name>" to your script.

Regards
Michel
Re: Problem with Listener in DB10g on Linux [message #316567 is a reply to message #282012] Fri, 25 April 2008 14:31 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
I am hvaing same problem after I added database startup script.
when I try to start listener or database I get error message:

please let me know if you need more info.

P/S I didn't mean to piggy on this poste.


Aziz
Re: Problem with Listener in DB10g on Linux [message #316569 is a reply to message #316567] Fri, 25 April 2008 14:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I didn't mean to piggy on this poste.

And did you do?
Start your own topic and if you don't give us your error you will have no answer, we are not mind readers.

Regards
Michel
Re: Problem with Listener in DB10g on Linux [message #316570 is a reply to message #316569] Fri, 25 April 2008 14:42 Go to previous message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
forgive my mistake. I just subscriped to this forum. I did start a new topic within Linux.

This is the error I get:
/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr ; error while loeading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adaptor error
TNS-00517: lost contact
Linux Error: 32: broken pipe.
Previous Topic: 2 listener entry for one listener in production
Next Topic: Oracle 9i on Windows2003 and tunnel with Client SSH
Goto Forum:
  


Current Time: Wed Dec 07 07:10:06 CST 2016

Total time taken to generate the page: 0.23734 seconds