On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
> 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...
>
Hi Marty,
Thanks for following up. I've created a tnsnames.ora file
in /usr/local/oracle/9.0.1/network/admin with the settings
appropriate to my host. When I run the following commands:
% setenv ORACLE_HOME /usr/local/oracle/9.0.1
% setenv ORACLE_SID VAPDEV
% oracledump -c -u myUser -p myPassword
I get the error message...
% Can't call method "do" on an undefined value at /home/doug/bin/oracledump line 95.
When I run it with the -x switch I see...
Configuration: (remove --explain/-x option to run with this configuration)
Database SID: VAPDEV
Database user: myUser
Database password: myPassword
Tables: All tables
Options:
--default-database Use default database (VAPDEV)
--with-table-comments Include table comments
--with-column-comments Include column comments
--default-precision Set to 18
--default-scale Set to 0
--complete-insert Includes list of column names in insert statements
I'm not a perl guy and I'm not sure what to make of it other than the
variables $nls_date_format, $nls_time_format, $nls_timestamp_format
have data at run-time.
Thanks again for your help so far...
--
Regards,
Doug
> 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]
