| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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'
case $REPLY in
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} = "xxxx" ]]
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 .
"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
> Cell 818 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: hamid.alavi_at_quovadx.com
>
> 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us
>
> 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: ListGuru_at_fatcity.com (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 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: hamid.alavi_at_quovadx.com
>
> 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: ListGuru_at_fatcity.com (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: Sutton, Reed
> INET: rsutton_at_fcg.com
>
> 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: ListGuru_at_fatcity.com (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: Suzy Vordos INET: lvordos_at_qwest.com 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: ListGuru_at_fatcity.com (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).Received on Fri Apr 05 2002 - 14:23:26 CST
 |
 |