RE: ora-12514
Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-12514
Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and
RE: ora-12514
Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain
RE: ora-12514
Actualy I have 8.1.6 8.1.7 on sun solaris not NT, the things which confusing me is the first day after installation I could connect to database and every thing was fine till I shutdown the database after taht I couldn't conect at all all the time get ora-12514 ERROR!!! don't find any thing between shtdown database this error? -Original Message- Sent: Friday, April 05, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: ora-12514
for unix think env var TNS_ADMIN for nt think registry entry TNS_ADMIN. [EMAIL PROTECTED] 04/05/02 01:07PM Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no matter what their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually) :-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know how you would do it on NT. HTH Reed -Original Message- Sent: Friday, April 05, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Tom, I have checked all the tnsname sqlnet.ora for both side client server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not??? second is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is any body know how to mange Dual Oracl-Home in one server, I beleive my problem is comming from having two oracle-home and when I try to connect, SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side couldn't find the SERVICE-NAME. Is anybody have any document to explain how to manage two version of oracle on same server, I really stucked with this problem. Thanks All -Original Message- Sent: Friday, April 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED)) ) WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED)) ) Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try connecting again. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any
Re: ora-12514
Also create links for the *.ora files from /var/opt/oracle to
$ORACLE_HOME/network/admin of each Oracle version, and set TNS_ADMIN
variable to /var/opt/oracle.
For multiple ORACLE_HOME's, write a script that prompts the user to
enter ORACLE_SID, then set ORACLE_HOME from oratab for that ORACLE_SID.
Execute it from .profile (or execute from command line as: .
scriptname). Something like this:
SPATH=/usr/bin:/usr/sbin:/usr/local/bin ; export SPATH
ORACLE_BASE=/opt/app/oracle ; export ORACLE_BASE
ORACLE_ADMIN=${ORACLE_BASE}/admin ; export ORACLE_ADMIN
TNS_ADMIN=/var/opt/oracle ; export TNS_ADMIN
ORATAB=${TNS_ADMIN}/oratab ; export ORATAB
print 'Select ORACLE_SID:'
PS3='SID? '
select sid in \
'orcl01' \
'orcl02'
do
case $REPLY in
1) SID=orcl01 ;;
2) SID=orcl02 ;;
*) print 'invalid.' ;;
esac
break
done
if [[ -n $sid -s ${ORATAB} ]]; then
ORACLE_SID=$sid ; export ORACLE_SID
ORACLE_HOME=`cat ${ORATAB} |grep ${ORACLE_SID} | \
awk -F: '/^[^#]/' |cut -d : -f2` ; export ORACLE_HOME
PATH=${SPATH}:${ORACLE_HOME}/bin ; export PATH
if [[ ${ORACLE_SID} = orcl01 || ${ORACLE_SID} = ]]
then NLS_LANG=AMERICAN_AMERICA.US7ASCII ; export NLS_LANG
else NLS_LANG=AMERICAN_AMERICA.UTF8 ; export NLS_LANG
fi
if [[ ! -n ${ORACLE_HOME} ]]; then
echo \nSelected ORACLE_SID not active in ${ORATAB}\n
else
print
print ORACLE_SID is $ORACLE_SID
print ORACLE_HOME is $ORACLE_HOME
print NLS_LANG is $NLS_LANG
print
cd .
fi
fi
Sutton, Reed wrote:
Hamid,
Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a
generic location so that all homes can access them. For instance, on HP-UX
we put them in /etc and on Solaris we put them in /var/opt/oracle. That way
all the different versions are accessing the same files, no matter what
their $ORACLE_HOME is set to. Unfortunately (fortunately for me, actually)
:-) we don't have any NT servers with multiple ORACLE_HOMEs, so I don't know
how you would do it on NT.
HTH
Reed
-Original Message-
Sent: Friday, April 05, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L
Tom,
I have checked all the tnsname sqlnet.ora for both side client server
nothing have been changed after I shutdown the database, I have a question
how come it was working perefect before I shutdown the database, don't know
when you shutdown it's change some thing on tnsname etc.. or not??? second
is can i have just one tnsname sqlnet for both Oracle 8.1.6 8.1.7 , is
any body know how to mange Dual Oracl-Home in one server, I beleive my
problem is comming from having two oracle-home and when I try to connect,
SQLPLUS still looking at 8.1.6 oracle-home and 8.1.6 tnsname on server side
couldn't find the SERVICE-NAME. Is anybody have any document to explain
how to manage two version of oracle on same server, I really stucked with
this problem. Thanks All
-Original Message-
Sent: Friday, April 05, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
Hamid,
I got stung with this just yesterday. Look closely at the TNSNAMES file.
Check this example:
WTWT_DBDOL0A1ADVWTW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATED))
)
WTWT_DBDOL0A1ADVWTW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521))
)
(CONNECT_DATA = (SID = wtwt)(SERVER = DEDICATED))
)
Look at the CONNECT_DATA line. Try changing the SERVICE_NAME to SID and try
connecting again.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, April 04, 2002 6:12 PM
To: Multiple recipients of list ORACLE-L
Hi list,
I asked this question this morning but no reply so I try again may be some
chace. I have created a new instance under 8.1.7 and test it yesterday was
fine, but this morning I try to shutdown the database and do some change on
it after complete shutdown when I try to open the database got ERROR
ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect
Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora
changed even I try connect from the server but no chance, we have two oracle
home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea
what's going on??? Appreciate your help. Thanks.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the
RE: ora-12514
Hamid - I would check your ORACLE_SID, ORACLE_HOME settings. Are you using TWO-TASK environment variable? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 5:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this question this morning but no reply so I try again may be some chace. I have created a new instance under 8.1.7 and test it yesterday was fine, but this morning I try to shutdown the database and do some change on it after complete shutdown when I try to open the database got ERROR ORA-12514 TNS LISTENER could not Resolve SERVICE-NAME given in connect Descriptor. I have checked every thing non of tnsnames.ora or sqlnet.ora changed even I try connect from the server but no chance, we have two oracle home at the moment 8.16 8.1.7 on Sun Solaris. Any body have any idea what's going on??? Appreciate your help. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514
Hi Brian , U need to define the service name in your TNSNAMES.ORA file ...Or use NET8 Easy Config define to define that .. U can find the TNSNAMES.ORA under Oracle home It looks like the following : Service Name .WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = Server IP Address)(Port = 1521)) ) (CONNECT_DATA = (SID = Service Name )) ) Substitute the values of Service Name , Server IP Address as required Regards -Original Message- From: Brian King [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 7:50 PM To: Multiple recipients of list ORACLE-L Subject: ORA-12514 Hi all, I am new to Oracle and am having problems getting started. I have installed Oracle (8.1.7) on a Windows 2000 Server and have no problems connecting on that machine (without specifying a host string). However, when I try to connect to it remotely (on a different domain) I get and error (ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor). I tested the listener and it is running. I have searched all over for help and cannot find any. I am simply tryin to connect remotely in order to begin developing VB apps in the future. Thanks for any input... Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-12514
Do you have that database in the tnsnames on the machine you are trying to access it from? If not, put if into the tnsnames file on that machine. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 12:20 PM Hi all, I am new to Oracle and am having problems getting started. I have installed Oracle (8.1.7) on a Windows 2000 Server and have no problems connecting on that machine (without specifying a host string). However, when I try to connect to it remotely (on a different domain) I get and error (ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor). I tested the listener and it is running. I have searched all over for help and cannot find any. I am simply tryin to connect remotely in order to begin developing VB apps in the future. Thanks for any input... Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-12514
Brian, In order for you to connect to the Oracle database on server A from server B you have to have the server A instance defined in the TNSnames.ora on server B. From the ORA message it appears that it in not defined and/or you do not have the IP address of server A in the server B host file. ROR mª¿ªm [EMAIL PROTECTED] 09/25/01 12:20PM Hi all, I am new to Oracle and am having problems getting started. I have installed Oracle (8.1.7) on a Windows 2000 Server and have no problems connecting on that machine (without specifying a host string). However, when I try to connect to it remotely (on a different domain) I get and error (ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor). I tested the listener and it is running. I have searched all over for help and cannot find any. I am simply tryin to connect remotely in order to begin developing VB apps in the future. Thanks for any input... Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514 TNS names could not resolve service name
Thanks for the tip - we just installed 8.1.6 on NT this afternoon and had the problem. Your solution did the trick!!! Laura H. Myers ATT Solutions-ITS [EMAIL PROTECTED] Phone: (336) 698-2375 Fax: (336) 698-2385 -- From: Ruiz, Mary A (CAP, CDI)[SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-12514 TNS names could not resolve service name Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruiz, Mary A (CAP, CDI) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Myers, Laura H, SITS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514 TNS names could not resolve service name
Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruiz, Mary A (CAP, CDI) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514 TNS names could not resolve service name
I want to connect using the @service_name -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-12514 TNS names could not resolve service name So you want to connect without the @string system/password as opposed to system/password@orcl? -Original Message- T (Richard) Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514 TNS names could not resolve service name
Try TWO_TASK on Unix, LOCAL on NT or ORA_DFLT_HOSTSTR on the NT predecessor. -Original Message- Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L So you want to connect without the @string system/password as opposed to system/password@orcl? -Original Message- T (Richard) Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-12514 TNS names could not resolve service name
Don't forget your domain in tnsnames.ora. A serv.= or serv.mydomain.com should work. oli On Thursday 01 February 2001 19:33, [EMAIL PROTECTED] wrote: Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514. This is a new installation. Everything is loaded on the same computer. It connects fine without service name but for other reasons I want to connect using service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl To: [EMAIL PROTECTED] [EMAIL PROTECTED] -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
