?
Solved

Can't connect to network services

Posted on 2001-07-10
8
Medium Priority
?
575 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Technology Partners: 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!

 
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
 

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

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

771 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