[Zope-DB] DCOracle2: Invalid Connection String

Kevin Taylor kevin@innovativelinux.com
05 Mar 2002 23:32:11 -0600


I am running into a problem with DCOracle2, when trying to connect to a
local Oracle 8.1.7 database.  From the Management interface, I can go to
my Oracle_database_connection object and attempt to update the
connection string to zope/zope2 (to match my test database).  This
always returns Invalid Connection String.

I am running:
SuSE 7.3 with their build of Zope 2.4.1
Oracle 8.1.7 on the same machine

I did update the zope start script to include LD_LIBRARY_PATH and
ORACLE_HOME variables.  I also tried going to a console, setting these
manually and running the z2.py directly.  

I referred to previous posts regarding the same problem, and am
including pertinent information related to those posts as well:



My sqlnet.ora:

# SQLNET.ORA Network Configuration File:
/opt/oracle/product/817/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = battletech.org

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)



My tnsnames.ora:

# TNSNAMES.ORA Network Configuration File:
/opt/oracle/product/817/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.BATTLETECH.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

MARAUDER.BATTLETECH.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = marauder)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = marauder)
    )
  )

INST1_HTTP.BATTLETECH.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = marauder)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = marauder)
      (PRESENTATION = http://admin)
    )
  )


Contents of my sqlnet.log:


***********************************************************************
Fatal NI connect error 12546, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/oracle/product/817/bin/oracle)(ARGV0=oraclemydb)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=marauder)(USER=nobody))))

  VERSION INFORMATION:
        TNS for Linux: Version 8.1.7.0.0 - Development
        Oracle Bequeath NT Protocol Adapter for Linux: Version 8.1.7.0.0
- Development
  Time: 05-MAR-2002 22:37:46
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12546
    TNS-12546: Message 12546 not found; No message file for
product=network, facility=TNS
    ns secondary err code: 12560
    nt main err code: 516
    TNS-00516: Message 516 not found; No message file for
product=network, facility=TNS
    nt secondary err code: 13
    nt OS err code: 0


***********************************************************************

(this repeats several times)






Can anyone give me an idea of how to solve the above issues?  If you
have some pertinent info, could you also cc my e-mail account
(kevin@innovativelinux.com), as I only receive daily batches from this
mailing list.

-- 

Kevin Taylor

-----------------------------
Innovative Linux Solutions

kevin@innovativelinux.com

Phone:  (972) 437-0343
Fax:  	(972) 422-8678
Cell:  	(214) 763-9507

280 E. FM 544
Suite 104-113
Murphy, TX 75094-4021
-----------------------------