Re: Newbie and Oracle/Linux

From: Harald Maier <maierh_at_myself.com>
Date: Mon, 18 Aug 2003 16:55:50 +0200
Message-ID: <m3he4f10cp.fsf_at_ate.maierh>


Sami Valkonen <anonymous_at_host.com> writes:

DBI connection with DBD-Oracle:

   $self->{DBI} = DBI->connect(

			       "DBI:Oracle:$db",$user,$pwd,
			       { "ora_session_mode" => $connect_mode,
				 "AutoCommit" => 0,
				 "RaiseError" => 1,
				 "PrintError" => 1
			       })
     || $self->error("Could not connect to database ($db)");


Method I:

db = "<service>"
pwd = "<pwd>"
connect_mode = 0 or 2 for SYSDBA
user = "<user>"

I am prefering the following Method II:

db = ""
pwd = "<pwd>"
connect_mode = 0
user = "<user>" or "<user_at_service>"

If only user is specified the the module takes the service name either from the TWO_TASK or the ORACLE_SID environment variable.

If user_at_service is specified then service should be a valid tnsnames.ora entry or a valid connect descriptor.

> mysqldump -u$dbuser -p$dbpass -h$dbhost -P$dbport --databases --opt $dbname

$ exp help=yes
$ imp help=yes

Harald Received on Mon Aug 18 2003 - 16:55:50 CEST

Original text of this message