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 Day. > > > > > > Hamid Alavi > > > Office 818 737-0526 > > > Cell 818 402-1987 > > > > > > The information contained in this message and any attachments is intended > > > only for the use of the individual or entity to which it is addressed, and > > > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > > > disclosure under applicable law. If you have received this message in > > error, > > > you are prohibited from copying, distributing, or using the information. > > > Please contact the sender immediately by return e-mail and delete the > > > original message from your system. > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Hamid Alavi > > > INET: [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). > > > > ======================= Confidentiality Statement ======================= > > The information contained in this message and any attachments is > > intended only for the use of the individual or entity to which it is > > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > > and exempt from disclosure under applicable law. If you have received > > this message in error, you are prohibited from copying, distributing, or > > using the information. Please contact the sender immediately by return > > e-mail and delete the original message from your system. > > ===================== End Confidentiality Statement ===================== > > > > The information contained in this message and any attachments is intended > > only for the use of the individual or entity to which it is addressed, and > > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > > disclosure under applicable law. If you have received this message in error, > > you are prohibited from copying, distributing, or using the information. > > Please contact the sender immediately by return e-mail and delete the > > original message from your system. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Hamid Alavi > > INET: [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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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).
