net8 setup questions...

From: <rev_frank_at_hotmail.com>
Date: Fri, 17 Mar 2000 03:57:49 GMT
Message-ID: <8asafs$nu2$1@nnrp1.deja.com>

Dear folks, I need help, here is the senario, I am new to the scene (our DBA comes

back in about a week) and I am trying to set up the follow senario: I have a

database (for simplicity call it DB) on an enterprise machine (call it

enterprise.woodside.com), I am trying to run net8 to connect to this machine from

various Linux machines, I believe that I have net8 properly installed on my Linux

machine (call it linux.woodside.com), because I am able to tns ping the machine,

as enterprise.woodsidelabs.com, enterpriseDB.woodsidelabs.com and as

DB.woodsidelabs.com,when I do this I get the following message:

bash$ tnsping db1.woodsidelabs.com

Attempting to contact

(ADDRESS=(PROTOCOL=TCP)(HOST=enterprise.woodsidelabs.com)(PORT=1521))

           OK (20 msec)
           bash$

           So I now figure hey I have the connection I can now make a
call through to the
           DB with a JDBCConnection call, I try the following command:

           /usr/local/jdk1.2.2/bin/java JDBCConnection
"oracle.jdbc.driver.OracleDriver"
           "jdbc:oracle:oci8:@enterprise.woodsidelabs.com" "frank"

"#$#&^%%&*"

It is at this point that I get the following error message:

           drive oracle.jdbc.driver.OracleDriver
           url jdbc:oracle:oci8:@db1.woodsidelabs.com
           java.sql.SQLException: ORA-12514: TNS:listener could not
resolve SERVICE_NAME
           given in connect descriptor

           at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
           at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
           at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
           at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
           at JDBCConnection.openDatabase(JDBCConnection.java:391)
           at JDBCConnection.<init>(JDBCConnection.java:74)
           at JDBCConnection.main(JDBCConnection.java:580)
           JDBCConnection.openDatabase: Unable to open.
           java.sql.SQLException: ORA-12514: TNS:listener could not
resolve SERVICE_NAME
           given in connect descriptor


           My tnsnames.ora file is listed as:

           # TNSNAMES.ORA Configuration

File:/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/network/admin/tns names.ora

# Generated by Oracle Net8 Assistant

           WLI =


           (DESCRIPTION =


           (ADDRESS_LIST =


           (ADDRESS = (PROTOCOL = TCP)(HOST = DB.woodsidelabs.com)(PORT


= 1521))
           )


           (CONNECT_DATA =


           (SERVICE_NAME = DBenterprise)


           )
           )


           My listener.ora:

           # LISTENER.ORA Configuration

File:/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/network/admin/lis tener.ora

# Generated by Oracle Net8 Assistant

           LISTENER =


           (DESCRIPTION =


           (ADDRESS = (PROTOCOL = TCP)(HOST = enterprise)(PORT = 1521))


           (PROTOCOL_STACK =


           (PRESENTATION = TTC)


           (SESSION = NS)


           )
           )

           SID_LIST_LISTENER =


           (SID_LIST =


           (SID_DESC =


           (GLOBAL_DBNAME = DBenterprise.woodsidelabs.com)


           (ORACLE_HOME =


/usr/local/oracle/8i/u01/app/oracle/product/8.1.5)


           (SID_NAME = enterpriseDB)


           )
           )


           My sqlnet.ora is:

           # SQLNET.ORA Configuration

File:/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/network/admin/sql net.ora

# Generated by Oracle Net8 Assistant

NAMES.DEFAULT_DOMAIN = woodsidelabs.com

SQLNET.EXPIRE_TIME = 0 SQLNET.CRYPTO_SEED = #$#$@#@##$###ect...

           IF ANYONE CAN HELP ME I WOULD GREATLY APPRECIATE IT, THE DBA IS COMING
           BACK FROM EUROPE IN ABOUT A WEEK AND I NEED TO TRY AND DO SOME
           TESTING, THANKS...            FRANK RIZZO Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 16 2000 - 21:57:49 CST