Re: [Zope] DCOracle Connection with Oracle 8.0.5
>From: "Celio C. Guimaraes" <[EMAIL PROTECTED]>
>
> 1) In order to connect successfully I had to drop the @sid parameter:
> dbc=DCOracle.Connect('scott/tiger@ora8')
> returns with error: ORA-12154 : TNS: could not resolve service name
>
> 2) I would like to connect to a remote oracle server. In this case the
> @sid parameter is essential.
> How could this problem be fixed? Is it a simple parsing problem in
> the oci_8.c Logon routine?
> which is the correct string to pe passed?
> @myserver.ic.unicamp.br:ora8 did not work either!
you have your tnsnames.ora file setup wrong. tha @host part is an "alias"
that oracle client uses to identify the hostmachine and instance you are
connecting to. The "alias" is defined in the tnsnames.ora file. If you need
help with it, contact me off list.
/dario
-
Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology
[EMAIL PROTECTED] ICQ will yield no hitsIT Systems & Services
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] [voipiri: Re: [Zope] DCOracle Connection with Oracle 8.0.5]
On Wed, Sep 13, 2000 at 10:20:15AM -0300, Celio C. Guimaraes wrote:
> 1) In order to connect successfully I had to drop the @sid parameter:
> dbc=DCOracle.Connect('scott/tiger@ora8')
> returns with error: ORA-12154 : TNS: could not resolve service name
I think this is default oracle behaviour. for local databases you
set the $ORACLE_SID connect with username/passwd. For remeote databases
you set $TWO_TASK or connect with username/passwd@SID .
You also need a correctly setup /etc/tnsnames.ora
--
Riku Voipio
[EMAIL PROTECTED]
09-862 60764
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] DCOracle Connection with Oracle 8.0.5
Celio C. Guimaraes writes:
> I have just installed the DCOracle package V 1.3.1b on a Linux Red Hat
> 6.2, to access an Oracle 8.0.5
> Server with python1.6
> I have run with success a few tests with the scott/tiger user tables,
> however:
>
> 1) In order to connect successfully I had to drop the @sid parameter:
> dbc=DCOracle.Connect('scott/tiger@ora8')
> returns with error: ORA-12154 : TNS: could not resolve service name
>
> 2) I would like to connect to a remote oracle server. In this case the
> @sid parameter is essential.
> How could this problem be fixed? Is it a simple parsing problem in
> the oci_8.c Logon routine?
> which is the correct string to pe passed?
> @myserver.ic.unicamp.br:ora8 did not work either!
We use this DCOracle version under Solaris 2.7 with
Oracle 8.1.6 without problem.
Especially, the "@host" works.
Thus, it does not look like a DCOracle problem.
Dieter
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] DCOracle Connection with Oracle 8.0.5
I have just installed the DCOracle package V 1.3.1b on a Linux Red Hat
6.2, to access an Oracle 8.0.5
Server with python1.6
I have run with success a few tests with the scott/tiger user tables,
however:
1) In order to connect successfully I had to drop the @sid parameter:
dbc=DCOracle.Connect('scott/tiger@ora8')
returns with error: ORA-12154 : TNS: could not resolve service name
2) I would like to connect to a remote oracle server. In this case the
@sid parameter is essential.
How could this problem be fixed? Is it a simple parsing problem in
the oci_8.c Logon routine?
which is the correct string to pe passed?
@myserver.ic.unicamp.br:ora8 did not work either!
Celio Guimaraes
Institute of Computing
Unicamp - Brazil
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
