RE: Still Problem with ORA-12514
Title: RE: Still Problem with ORA-12514 I have had one instance (out of many) where using a hostname would not work. I was getting the same error and I had to use the IP address in the Listener to get it to work. There were two IP addresses and the listener was accessing the second address where the client was accessing the first IP address. Laura -Original Message- From: Danisment Gazi Unal [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Still Problem with ORA-12514 Hi, If you are sure other recomendations are correct, open your tnsnames.ora with a text editor, check if there is a weird character(i.e. tabs) in it. Or remove your tnsnames.ora, then recreate it. danisment... Suzy Vordos wrote: > You can have a tnsnames.ora in each ORACLE_HOME, but not recommended > because you'd need to maintain multiple copies. > > Try stopping/restarting the listener, and be certain you're running only > the listener for the highest version of Oracle. > > On rare occasion something in sqlnet.ora causes problems. You could > temporarily rename it (or comment out the contents) and see if that > makes a difference. > > Hamid Alavi wrote: > > > > I did it and still NOT working, > > Question? Can I have one tnsnames.ora for BOTH oracle-home or not??? > > > > -Original Message- > > Sent: Friday, April 05, 2002 12:29 PM > > To: Multiple recipients of list ORACLE-L > > > > In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora > > remove SID_DESC for that database as it's really not needed for 8i. > > Here's what my config looks like: > > > > # -- > > # Filename: listener.ora > > # -- > > LSNR01 = > > (ADDRESS_LIST = > > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) > > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521)) > > ) > > STARTUP_WAIT_TIME_LSNR01 = 0 > > CONNECT_TIMEOUT_LSNR01 = 10 > > TRACE_LEVEL_LSNR01 = OFF > > > > LSNR02 = > > (ADDRESS_LIST = > > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) > > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526)) > > ) > > STARTUP_WAIT_TIME_LSNR02 = 0 > > CONNECT_TIMEOUT_LSNR02 = 10 > > TRACE_LEVEL_LSNR02 = OFF > > > > # -- > > # Filename: tnsnames.ora > > # -- > > orcl01 = > > (DESCRIPTION = > > (SDU = 8192)(TDU = 8192) > > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521)) > > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526)) > > (CONNECT_DATA = (SERVICE_NAME = orcl01.world)) > > ) > > > > Hamid Alavi wrote: > > > > > > I am really Buffled, and need your help guys. Here is my Tnsnames.ora & > > > listener.ora & sqlnet.ora in server side: > > > > > > db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , > > > service_name = CMS.HOLLYWOOD > > > > > > LISTENER.ora on Server: > > > # LISTENER.ORA Network Configuration File: > > > /u04/app/oracle/network/admin/listener.ora > > > # Generated by Oracle configuration tools. > > > > > > LISTENER = > > > (DESCRIPTION_LIST = > > > (DESCRIPTION = > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > > > ) > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > > ) > > > ) > > > (DESCRIPTION = > > > (PROTOCOL_STACK = > > > (PRESENTATION = GIOP) > > > (SESSION = RAW) > > > ) > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) > > > ) > > > ) > > > > > > SID_LIST_LISTENER = > > > (SID_LIST = > > > (SID_DESC = > > > (SID_NAME = PLSExtProc) > > > (ORACLE_HOME = /u04/app/oracle) > > > (PROGRAM = extproc) > > > ) > > > (SID_DESC = > > > (GLOBAL_DBNAME = CMS.HOLLYWOOD) > > > (ORACLE_HOME = /u04/app/oracle) > > > (SID_NAME = CMS) > > > ) > > > ) > > > > > > > > > > > TNSNAMES.ora on server side: > > > > > > # TNSNAMES.ORA Network Configuration File: > > > /u04/app/oracle/network/ad
Re: Still Problem with ORA-12514
Hi, If you are sure other recomendations are correct, open your tnsnames.ora with a text editor, check if there is a weird character(i.e. tabs) in it. Or remove your tnsnames.ora, then recreate it. danisment... Suzy Vordos wrote: > You can have a tnsnames.ora in each ORACLE_HOME, but not recommended > because you'd need to maintain multiple copies. > > Try stopping/restarting the listener, and be certain you're running only > the listener for the highest version of Oracle. > > On rare occasion something in sqlnet.ora causes problems. You could > temporarily rename it (or comment out the contents) and see if that > makes a difference. > > Hamid Alavi wrote: > > > > I did it and still NOT working, > > Question? Can I have one tnsnames.ora for BOTH oracle-home or not??? > > > > -Original Message- > > Sent: Friday, April 05, 2002 12:29 PM > > To: Multiple recipients of list ORACLE-L > > > > In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora > > remove SID_DESC for that database as it's really not needed for 8i. > > Here's what my config looks like: > > > > # -- > > # Filename: listener.ora > > # -- > > LSNR01 = > > (ADDRESS_LIST = > > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) > > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521)) > > ) > > STARTUP_WAIT_TIME_LSNR01 = 0 > > CONNECT_TIMEOUT_LSNR01 = 10 > > TRACE_LEVEL_LSNR01 = OFF > > > > LSNR02 = > > (ADDRESS_LIST = > > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) > > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526)) > > ) > > STARTUP_WAIT_TIME_LSNR02 = 0 > > CONNECT_TIMEOUT_LSNR02 = 10 > > TRACE_LEVEL_LSNR02 = OFF > > > > # -- > > # Filename: tnsnames.ora > > # -- > > orcl01 = > > (DESCRIPTION = > > (SDU = 8192)(TDU = 8192) > > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521)) > > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526)) > > (CONNECT_DATA = (SERVICE_NAME = orcl01.world)) > > ) > > > > Hamid Alavi wrote: > > > > > > I am really Buffled, and need your help guys. Here is my Tnsnames.ora & > > > listener.ora & sqlnet.ora in server side: > > > > > > db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , > > > service_name = CMS.HOLLYWOOD > > > > > > LISTENER.ora on Server: > > > # LISTENER.ORA Network Configuration File: > > > /u04/app/oracle/network/admin/listener.ora > > > # Generated by Oracle configuration tools. > > > > > > LISTENER = > > > (DESCRIPTION_LIST = > > > (DESCRIPTION = > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > > > ) > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > > ) > > > ) > > > (DESCRIPTION = > > > (PROTOCOL_STACK = > > > (PRESENTATION = GIOP) > > > (SESSION = RAW) > > > ) > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) > > > ) > > > ) > > > > > > SID_LIST_LISTENER = > > > (SID_LIST = > > > (SID_DESC = > > > (SID_NAME = PLSExtProc) > > > (ORACLE_HOME = /u04/app/oracle) > > > (PROGRAM = extproc) > > > ) > > > (SID_DESC = > > > (GLOBAL_DBNAME = CMS.HOLLYWOOD) > > > (ORACLE_HOME = /u04/app/oracle) > > > (SID_NAME = CMS) > > > ) > > > ) > > > > > > > > > > > TNSNAMES.ora on server side: > > > > > > # TNSNAMES.ORA Network Configuration File: > > > /u04/app/oracle/network/admin/tnsnames.ora > > > # Generated by Oracle configuration tools. > > > > > > CMS = > > > (DESCRIPTION = > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > > ) > > > (CONNECT_DATA = > > > (SERVICE_NAME = CMS) > > > ) > > > ) > > > > > > INST1_HTTP = > > > (DESCRIPTION = > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > > ) > > > (CONNECT_DATA = > > > (SERVER = SHARED) > > > (SERVICE_NAME = CMS) > > > (PRESENTATION = http://admin) > > > ) > > > ) > > > > > > EXTPROC_CONNECTION_DATA = > > > (DESCRIPTION = > > > (ADDRESS_LIST = > > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > > > ) > > > (CONNECT_DATA = > > > (SID = PLSExtProc) > > > (PRESENTATION = RO) > > > ) > > > ) > > > > > > > > > # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora > > > # Generated by Oracle configuration tools. > > > > > > # NAMES.DEFAULT_DOMAIN = hollywood > > > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) > > > > > > I know all of you are busy but may be you can see some thing which I > > > couldn't, I did my best and couldn't solve the problem. > > > Thanks allot > > > Have a nice D
Re: Still Problem with ORA-12514
You can have a tnsnames.ora in each ORACLE_HOME, but not recommended because you'd need to maintain multiple copies. Try stopping/restarting the listener, and be certain you're running only the listener for the highest version of Oracle. On rare occasion something in sqlnet.ora causes problems. You could temporarily rename it (or comment out the contents) and see if that makes a difference. Hamid Alavi wrote: > > I did it and still NOT working, > Question? Can I have one tnsnames.ora for BOTH oracle-home or not??? > > -Original Message- > Sent: Friday, April 05, 2002 12:29 PM > To: Multiple recipients of list ORACLE-L > > In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora > remove SID_DESC for that database as it's really not needed for 8i. > Here's what my config looks like: > > # -- > # Filename: listener.ora > # -- > LSNR01 = > (ADDRESS_LIST = > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521)) > ) > STARTUP_WAIT_TIME_LSNR01 = 0 > CONNECT_TIMEOUT_LSNR01 = 10 > TRACE_LEVEL_LSNR01 = OFF > > LSNR02 = > (ADDRESS_LIST = > (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) > (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526)) > ) > STARTUP_WAIT_TIME_LSNR02 = 0 > CONNECT_TIMEOUT_LSNR02 = 10 > TRACE_LEVEL_LSNR02 = OFF > > # -- > # Filename: tnsnames.ora > # -- > orcl01 = > (DESCRIPTION = > (SDU = 8192)(TDU = 8192) > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521)) > (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526)) > (CONNECT_DATA = (SERVICE_NAME = orcl01.world)) > ) > > Hamid Alavi wrote: > > > > I am really Buffled, and need your help guys. Here is my Tnsnames.ora & > > listener.ora & sqlnet.ora in server side: > > > > db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , > > service_name = CMS.HOLLYWOOD > > > > LISTENER.ora on Server: > > # LISTENER.ORA Network Configuration File: > > /u04/app/oracle/network/admin/listener.ora > > # Generated by Oracle configuration tools. > > > > LISTENER = > > (DESCRIPTION_LIST = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > > ) > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > ) > > ) > > (DESCRIPTION = > > (PROTOCOL_STACK = > > (PRESENTATION = GIOP) > > (SESSION = RAW) > > ) > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) > > ) > > ) > > > > SID_LIST_LISTENER = > > (SID_LIST = > > (SID_DESC = > > (SID_NAME = PLSExtProc) > > (ORACLE_HOME = /u04/app/oracle) > > (PROGRAM = extproc) > > ) > > (SID_DESC = > > (GLOBAL_DBNAME = CMS.HOLLYWOOD) > > (ORACLE_HOME = /u04/app/oracle) > > (SID_NAME = CMS) > > ) > > ) > > > > > > > TNSNAMES.ora on server side: > > > > # TNSNAMES.ORA Network Configuration File: > > /u04/app/oracle/network/admin/tnsnames.ora > > # Generated by Oracle configuration tools. > > > > CMS = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = CMS) > > ) > > ) > > > > INST1_HTTP = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > > ) > > (CONNECT_DATA = > > (SERVER = SHARED) > > (SERVICE_NAME = CMS) > > (PRESENTATION = http://admin) > > ) > > ) > > > > EXTPROC_CONNECTION_DATA = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > > ) > > (CONNECT_DATA = > > (SID = PLSExtProc) > > (PRESENTATION = RO) > > ) > > ) > > > > > > # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora > > # Generated by Oracle configuration tools. > > > > # NAMES.DEFAULT_DOMAIN = hollywood > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) > > > > I know all of you are busy but may be you can see some thing which I > > couldn't, I did my best and couldn't solve the problem. > > Thanks allot > > Have a nice Day. > > > > 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
RE: Still Problem with ORA-12514
I did it and still NOT working, Question? Can I have one tnsnames.ora for BOTH oracle-home or not??? -Original Message- Sent: Friday, April 05, 2002 12:29 PM To: Multiple recipients of list ORACLE-L In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora remove SID_DESC for that database as it's really not needed for 8i. Here's what my config looks like: # -- # Filename: listener.ora # -- LSNR01 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521)) ) STARTUP_WAIT_TIME_LSNR01 = 0 CONNECT_TIMEOUT_LSNR01 = 10 TRACE_LEVEL_LSNR01 = OFF LSNR02 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526)) ) STARTUP_WAIT_TIME_LSNR02 = 0 CONNECT_TIMEOUT_LSNR02 = 10 TRACE_LEVEL_LSNR02 = OFF # -- # Filename: tnsnames.ora # -- orcl01 = (DESCRIPTION = (SDU = 8192)(TDU = 8192) (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521)) (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526)) (CONNECT_DATA = (SERVICE_NAME = orcl01.world)) ) Hamid Alavi wrote: > > I am really Buffled, and need your help guys. Here is my Tnsnames.ora & > listener.ora & sqlnet.ora in server side: > > db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , > service_name = CMS.HOLLYWOOD > > LISTENER.ora on Server: > # LISTENER.ORA Network Configuration File: > /u04/app/oracle/network/admin/listener.ora > # Generated by Oracle configuration tools. > > LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > ) > (DESCRIPTION = > (PROTOCOL_STACK = > (PRESENTATION = GIOP) > (SESSION = RAW) > ) > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) > ) > ) > > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = /u04/app/oracle) > (PROGRAM = extproc) > ) > (SID_DESC = > (GLOBAL_DBNAME = CMS.HOLLYWOOD) > (ORACLE_HOME = /u04/app/oracle) > (SID_NAME = CMS) > ) > ) > > > TNSNAMES.ora on server side: > > # TNSNAMES.ORA Network Configuration File: > /u04/app/oracle/network/admin/tnsnames.ora > # Generated by Oracle configuration tools. > > CMS = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = CMS) > ) > ) > > INST1_HTTP = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVER = SHARED) > (SERVICE_NAME = CMS) > (PRESENTATION = http://admin) > ) > ) > > EXTPROC_CONNECTION_DATA = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (CONNECT_DATA = > (SID = PLSExtProc) > (PRESENTATION = RO) > ) > ) > > > # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora > # Generated by Oracle configuration tools. > > # NAMES.DEFAULT_DOMAIN = hollywood > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) > > I know all of you are busy but may be you can see some thing which I > couldn't, I did my best and couldn't solve the problem. > Thanks allot > Have a nice Day. > > 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 informati
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 &
Re: Still Problem with ORA-12514
In tnsnames.ora set SERVICE_NAME=cms.hollywood, and in listener.ora remove SID_DESC for that database as it's really not needed for 8i. Here's what my config looks like: # -- # Filename: listener.ora # -- LSNR01 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01)) (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1521)) ) STARTUP_WAIT_TIME_LSNR01 = 0 CONNECT_TIMEOUT_LSNR01 = 10 TRACE_LEVEL_LSNR01 = OFF LSNR02 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02)) (ADDRESS= (PROTOCOL= TCP)(Host= host.domain)(Port= 1526)) ) STARTUP_WAIT_TIME_LSNR02 = 0 CONNECT_TIMEOUT_LSNR02 = 10 TRACE_LEVEL_LSNR02 = OFF # -- # Filename: tnsnames.ora # -- orcl01 = (DESCRIPTION = (SDU = 8192)(TDU = 8192) (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1521)) (ADDRESS = (PROTOCOL=TCP)(HOST=host.domain)(PORT=1526)) (CONNECT_DATA = (SERVICE_NAME = orcl01.world)) ) Hamid Alavi wrote: > > I am really Buffled, and need your help guys. Here is my Tnsnames.ora & > listener.ora & sqlnet.ora in server side: > > db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , > service_name = CMS.HOLLYWOOD > > LISTENER.ora on Server: > # LISTENER.ORA Network Configuration File: > /u04/app/oracle/network/admin/listener.ora > # Generated by Oracle configuration tools. > > LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > ) > (DESCRIPTION = > (PROTOCOL_STACK = > (PRESENTATION = GIOP) > (SESSION = RAW) > ) > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) > ) > ) > > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = /u04/app/oracle) > (PROGRAM = extproc) > ) > (SID_DESC = > (GLOBAL_DBNAME = CMS.HOLLYWOOD) > (ORACLE_HOME = /u04/app/oracle) > (SID_NAME = CMS) > ) > ) > > > TNSNAMES.ora on server side: > > # TNSNAMES.ORA Network Configuration File: > /u04/app/oracle/network/admin/tnsnames.ora > # Generated by Oracle configuration tools. > > CMS = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = CMS) > ) > ) > > INST1_HTTP = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVER = SHARED) > (SERVICE_NAME = CMS) > (PRESENTATION = http://admin) > ) > ) > > EXTPROC_CONNECTION_DATA = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (CONNECT_DATA = > (SID = PLSExtProc) > (PRESENTATION = RO) > ) > ) > > > # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora > # Generated by Oracle configuration tools. > > # NAMES.DEFAULT_DOMAIN = hollywood > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) > > I know all of you are busy but may be you can see some thing which I > couldn't, I did my best and couldn't solve the problem. > Thanks allot > Have a nice Day. > > 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: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San D
RE: Still Problem with ORA-12514
Do you have identical TNSNAMES.ORA files in both ORACLE_HOMEs? Have you done a ps -ef | grep ora to see if the instance is started? This error is caused either by a bad SERVICE_NAME in the TNSNAMES.ORA file or else because the instance is not started. "ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Cause: The service name specified in the connect descriptor is incorrect, or the database service is not registered with the listener. Action: Perform these steps: 1. Check to make sure the SERVICE_NAME specified in the connect descriptor is correct. 2. Ensure the database instance is running. If the instance not running, start it so that it can register with the listener. You can use the Listener Control utility SERVICES command to see what services are currently registered with the listener. " You can check the LISTENER by going to the command line at ORACLE_HOME/bin and entering lsnrctl services If you don't see an entry for CMS then enter lsnrctl reload and then lsnrctl services. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Still Problem with ORA-12514
Another thing is when I do TNSPING to the instance it's OK but still can not connect, ORA-12514 ! -Original Message- Sent: Friday, April 05, 2002 10:47 AM To: Multiple recipients of list ORACLE-L Hamid, did you try changing SERVICE_NAME to SID within the TNSNAMES file? CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) <=== change to SID = CMS ) ) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, April 05, 2002 1:08 PM To: Multiple recipients of list ORACLE-L I am really Buffled, and need your help guys. Here is my Tnsnames.ora & listener.ora & sqlnet.ora in server side: db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. 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
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). ===
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
RE: Still Problem with ORA-12514
Hamid, did you try changing SERVICE_NAME to SID within the TNSNAMES file? CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) <=== change to SID = CMS ) ) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, April 05, 2002 1:08 PM To: Multiple recipients of list ORACLE-L I am really Buffled, and need your help guys. Here is my Tnsnames.ora & listener.ora & sqlnet.ora in server side: db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. 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
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
Still Problem with ORA-12514
I am really Buffled, and need your help guys. Here is my Tnsnames.ora & listener.ora & sqlnet.ora in server side: db-name = "CMS" , db_domain="hollywood" , instance_name = CMS , service_name = CMS.HOLLYWOOD LISTENER.ora on Server: # LISTENER.ORA Network Configuration File: /u04/app/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u04/app/oracle) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = CMS.HOLLYWOOD) (ORACLE_HOME = /u04/app/oracle) (SID_NAME = CMS) ) ) TNSNAMES.ora on server side: # TNSNAMES.ORA Network Configuration File: /u04/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CMS) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOLLYWOOD)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = CMS) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # SQLNET.ORA Configuration File:/u01/app/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools. # NAMES.DEFAULT_DOMAIN = hollywood NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) I know all of you are busy but may be you can see some thing which I couldn't, I did my best and couldn't solve the problem. Thanks allot Have a nice Day. 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).
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 address
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
Check the value of service_names: SQL> show parameter service_names Then make sure your tnsnames.ora uses SERVICE_NAME (not SID) within CONNECT_DATA and the value of SERVICE_NAME matches the value returned by the above query (normally db_name.db_domain) CONNECT_DATA=(SERVICE_NAME=db_name.db_domain)) Hamid Alavi wrote: > > 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: Suzy Vordos 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
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).
ora-12514
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).
ORA-12514
Dear List, I have created a new instance on 8.1.7 under sun solaris, then try to shutdown the databse to change some parameter after changing the ini.ora when I try to open the database Got this error: ORA-12514 Listener could not resolve SERVICE-NAME given in connect descriptor. Strange is I used DBA Studion to shutdown database with internal/oracle and Havn't change any thing for service-name how come this error araise??? Any Idea? Thanks in advance 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).
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
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
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).
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).
ORA:12514 Error
Hi, I had installed oracle 8.1.7 on WINNT and installed oracle client with administrator utility on win2k system. When i want to connect to this client on win2k to server on winnt. But i am getting the error ORA:12514. Can any one slove this for me. The listener.ora and tnsnames.ora files seems to be ok. Thanks in advance Bhanu __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gorthy BhanuPrakash 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 AT&T 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
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).
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
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).
ORA-12514 TNS names could not resolve service name
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).
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
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).