Oracle 8.0.5 client to Oracle 7.3.2 server connection

From: Eddie Azman <eddie_at_mivec.net>
Date: 10 Jun 2002 00:52:37 -0700
Message-ID: <a256f528.0206092352.ac59853_at_posting.google.com>

Hello,

I have problems connecting to an Oracle 7.3.2 server from an Oracle 8.0.5 client machine. I am able to do a tnsping and obtan a successful response from the server. However, whenever I use SQLPlus to connect to the server from the client I get the message ORA-01034: ORACLE not available.

The server machine is a Sun SPARC machine running SunOS 5.5.1 and my client is a Pentium III Redhat Linux 6.1 machine.

Below are some relevant files on the server machine.

tnsnames.ora

---

dbserver.mydomain.com =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = TCP.mydomain.com)

          (PROTOCOL = TCP)

          (Host = mydomainweb1.mydomain.com)


          (Port = 1526)


        )

    )
    (CONNECT_DATA =

      (SID = dbserver)
         (GLOBAL_NAME = dbserver.mydomain.com)

    )
  )

dbserver =

        (DESCRIPTION =
                (ADDRESS =
                        (PROTOCOL = IPC)
                        (KEY = dbserver.mydomain.com)
                )
                (CONNECT_DATA =
                        (SID = dbserver)
                )
        )

listener.ora

---

SQLNET.AUTHENTICATION_SERVICES = (NONE) USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= dbserver.mydomain.com)


        )
        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= dbserver)


        )
        (ADDRESS = 


          (COMMUNITY = TCP.mydomain.com)

          (PROTOCOL = TCP)

          (Host = mydomainweb1.mydomain.com)


          (Port = 1526)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = dbserver.mydomain.com)
      (SID_NAME = dbserver)
      (ORACLE_HOME = /pubsys/app/oracle/product/7.3.2)
      (PRESPAWN_MAX = 10)

    )
  )

sqlnet.ora

---

AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = ON
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = mydomain.com
NAME.DEFAULT_ZONE = mydomain.com
SQLNET.CRYPTO_SEED = "-xxxxxxxxxx-xxxxxxxx"   

native.ora

---

dbserver,mydomain.com,
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.mydomain.com)(PROTOCOL=TCP)(Host=mydomainweb1.mydomain.com)(Port=1526)))(CONNECT_DATA=(SID=dbserver)(GLOBAL_NAME=dbserver.mydomain.com)))

tnsnav.ora

---

LOCAL_COMMUNITIES =
  (COMMUNITY_LIST =
    (COMMUNITY = TCP.mydomain.com)
  )

topology.ora

---

LISTENER_mydomainweb1.mydomain.com = (ORACLE_LISTENER, mydomainweb1.mydomain.com)
dbserver.mydomain.com = (ORACLE_DATABASE, mydomainweb1.mydomain.com, LISTENER_mydomainweb1.mydomain.com)

---

On the client machine

---

tnsnames.ora

---

dbserver.mydomain.com =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = TCP.mydomain.com)

          (PROTOCOL = TCP)

          (Host = mydomainweb1.mydomain.com)


          (Port = 1526)


        )

    )
    (CONNECT_DATA =

      (SID = dbserver)
         (GLOBAL_NAME = dbserver.mydomain.com)

    )
  )

sqlplus connection string

---

sqlplus username/password_at_dbserver.mydomain.com

tnsping

---

> tnsping dbserver.mydomain.com

TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 10-JUN-02 15:47:19 (c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact
(ADDRESS=(COMMUNITY=TCP.mydomain.com)(PROTOCOL=TCP)(Host=mydomainweb1.mydomain.com)(Port=1526)) OK (10 msec)

Would appreciate any help. Thanks in advance.

Regards,

Eddie Received on Mon Jun 10 2002 - 09:52:37 CEST