Need Help

From: "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 20 Sep 2004 14:55:07 +0530
HI,
I am having 9.0.2 version of oracle running on windows 2000 professional.
The Problem I am facing when I am trying create net8 config.

the error as follows
"

Connecting...ORA-03113: end-of-file on communication channel
The test did not succeed.

Some of the information you provided may be incorrect.
Press Back to review the information provided for net service name, or Change 
Login to change username. 
"

I am having oracle 8i software also in my PC.


SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
MSLDEVP9.US.ORACLE.COM


the Red color ones are created by me but not working.........

# TNSNAMES.ORA Network Configuration File: 
C:\Software\Oracle\Database\Oracle9i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXAMPLE3.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = nmp.world)(PROTOCOL = NMP)(Server = 
FinanceServer1)(Pipe = ORAPIPE))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )
  )

EXAMPLE1.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 
Production1)(Port = 1521))
    )
    (CONNECT_DATA =
      (SID = SID1)
    )
  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = beq.world)(PROTOCOL = BEQ)(PROGRAM = 
oracle73)(ARGV0 = oracle73ORCL)(ARGS = 
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )
  )

SREE.KPIT.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SrinivasT.kpit.com)(PORT = 1521))
    )
    (CONNECT_DATA =
     (SID = msldevp9)
      (SERVICE_NAME = srinivast.kpit.com)
       (GLOBAL_NAME=msldevp9.world) 
    )
  )


EXAMPLE2.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = spx.world)(PROTOCOL = SPX)(Service = Server_lsnr))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )
  )

MSLDEVP9.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 127.0.0.1)(Port 
= 1521))
    )
    (CONNECT_DATA =
      (SID = msldevp9)
      (SERVICE=SREE);
    )
  )

Help me......

Regards,
Srinivas

--
//www.freelists.org/webpage/oracle-l
Need Help

Other related posts:
