Re: Newbie and Oracle/Linux
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