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).