• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • Last Modified:

Can't connect to network services

I have installed release 8.1.7 on a Sun Ultra 10 with the typical mode. The listener.ora and tnsnames.ora were both configured automatically at the end of the installation. They are as follow,

listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 2481))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = sid.mycompany.com)
      (ORACLE_HOME = /u01/oracle/product/8.1.7)
      (SID_NAME = sid)
    )
  )


tnsnames.ora

INST1_HTTP.mycompany.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = sid.mycompany.com)
     (PRESENTATION = http://admin)
    )
  )



sid.mycompany.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sid.mycompany.com)
    )
  )

EXTPROC_CONNECTION_DATA.mycompany.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

There are three service discriptors(network service name) in the tnsnames files. I am using this tnsname.ora as naming method. But I can only connect by sid.mycompany.com. When I tryied to connect by the other two, I got the error message:
ORA-03113: end-of-file on communication channel.

Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

   Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

The Cause and Act don't help.

I tested these two discriptors by the tnsping and trcroute unitilies, they pass the test. But they can't pass the test of Net8 assistnat. Since the INST1_HTTP.mycompany.com requires to be connected to a shared server, I configured the system as MTS with two dispatchers.

Could somebody help me out? Thanks.
0
pren
Asked:
pren
1 Solution
 
annu_vinayakCommented:
Backup the original copy of the tnsnames.ora file at the client end and try to check it with the follwing file (tnsnames.ora is located in ORACLE_HOME/NET80/ADMIN): -

SERVICE-NAME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SERVICE_NAME)
    )
  )

Change the following items with your configuration:-
1. SERVICE_NAME :- name u want to give to your connection

2. HOST_NAME : - name of the server where oracle db is  configured

3. SERVICE_NAME : - with the name of the database located on the server
 
If the above solution don't work then please check your 'HOST_NAME' in the original file and then reboot the machine.

Hope this helps you.
0
 
prenAuthor Commented:
Hi annu_vinayak,

I checked all the items you listed, they are right. I also reboot the machine, it doesn't work too.

Peng
0
 
sunsapollosCommented:

  You can connect to database with sid desc.But other fail.
inst_http connect:http server is running?this is for http server connect.
  EXTPROC_CONNECTION_DATA.mycompany.com connect: your exproc server is running?This is for extproc server.
  normal,we only use sid connect to oper database.I think your dataabse and connect is normal
 
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
annu_vinayakCommented:
Dear Pren,

You can work the other way out, try deleting the original tnsnames.ora and listner.ora files and then re-create them through 'Net8 Configuration Assistant'.

Hope this works out.
0
 
prenAuthor Commented:
Hi annu_vinayak ,

I am sorry for the delay of response. I tried NetCA. But netCA can't configure the server type of a peticular discriptor, I mean dedicated or shared. Since the sid and inst1_http are all the same except server type, I really want to set this up in configuration.

Peng
0
 
MindphaserCommented:
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
DanRollinsCommented:
Lacking timely response from pren or contributing experts, but seeing that there is some useful info here, I recommend:

    Refund points and save as a 0-pt PAQ.

DanRollins -- EE database cleanup volunteer
0
 
MoondancerCommented:
Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
50 points refunded, question moved to PAQ at zero points and closed.
Moondancer - EE Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now