Problem with Listener in DB10g on Linux [message #282009] |
Tue, 20 November 2007 06:43  |
sahiti Messages: 7 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 #282019 is a reply to message #282009 ] |
Tue, 20 November 2007 07:31   |
Michel Cadot Messages: 17605 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
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 #282763 is a reply to message #282009 ] |
Fri, 23 November 2007 06:32   |
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   |
Michel Cadot Messages: 17605 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
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 #315340 is a reply to message #282770 ] |
Mon, 21 April 2008 03:52   |
sahiti Messages: 7 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   |
Michel Cadot Messages: 17605 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
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   |
varu123 Messages: 713 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   |
sahiti Messages: 7 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   |
Michel Cadot Messages: 17605 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
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   |
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   |
Michel Cadot Messages: 17605 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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  |
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.
|
|
|