Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm
5.5.3 tsnames.ora File
the file
ORACLE_HOME/network/admin/tnsnames.ora must point to the listener (i.e., the
TCP/IP port) on the database server. (ORACLE_HOME is the directory on Unix
where Oracle is installed.) For example,
ora_db0_net=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=test-console.think.com)
(PORT=1521)
)
(CONNECT_DATA=
(SID=ORCL)
)
)
Note: Do not use tabs in the file tnsnames.ora.
*OracleDump is performed by (SID=ORCL)*
Keep us apprised to your progress...
Marty Gainty
----- Original Message -----
From: "Doug Poland" <[EMAIL PROTECTED]>
To: "Jim Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed program)
> On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
> > > I'm trying to figure out how to use the contributed program
> > > "oracledump" in an environment where I don't have a login to the *nix
> > > host running Oracle. All my connectivity to the Oracle host is via
> > > port 1521 and JDBC.
> > >
> > > The oracle dump command seems to be looking for a SID in a file called
> > > tnsnames.ora. Those do not exist on the system I am using. Is it
> > > possible to still use oracledump in this case?
> > >
> > I doubt it. It looks as if oracledump requires Oracle's network layer
> > (SQL*Net) and
> > unless you have that you can't do anything.
> >
> > The oracle thin JDBC driver implements
> > SQL*Net for java only, but the other Oracle jdbc drivers require SQL*Net
> >
> Thanks for the reply. Looks like I'll have to roll my own in Java.
>
> --
> Regards,
> Doug
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
