[Zope-DB] Connection to Oracle DB

[Cliff Ford]

Umashankar Rao wrote:
> But how to define my database connection parameters like
> username/passwd and SID?

You need an entry in tnsnames.ora that looks like this:

YOURID =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = address.of.your.server)(PORT = 
XXXX))
     )
     (CONNECT_DATA =
       (SID = yourid)
     )
   )

XXXX is the actual port number the database is using.

> 
> Can you please give me the navigation from 
> http://localhost:8080/manage ??? Is it the right adaptor i
> downloaded?/

You should see Z Oracle Database Connection in the Add list (if the 
installation was successful). If so...

Your connection string should look like this:

username/password at YOURID

HTH

Cliff