Solved

Can't connect to network services

Posted on 2001-07-10
8
547 Views
Last Modified: 2008-02-26
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
Comment
Question by:pren
8 Comments
 
LVL 1

Expert Comment

by:annu_vinayak
ID: 6271739
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
 

Author Comment

by:pren
ID: 6273209
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
 

Expert Comment

by:sunsapollos
ID: 6275204

  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
 
LVL 1

Expert Comment

by:annu_vinayak
ID: 6275613
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:pren
ID: 6280805
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
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7038095
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
 
LVL 49

Expert Comment

by:DanRollins
ID: 7053118
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
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7054071
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now