Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Can't connect to network services

Posted on 2001-07-10
8
Medium Priority
?
584 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

604 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