Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 667
  • Last Modified:

Perl connect to Oracle mounted database as sys user

I am trying to connect to a mounted standby Oracle database using DBI:Oracle

To make this connection I must user a connect string similar to sys/password@dbname as sysdba

The "as sysdba" is required to connect as sys user.

I am looking for the correct connect string syntax that includes as sysdba in it.
0
TOWELLR
Asked:
TOWELLR
1 Solution
 
TobiasCommented:
Hi !

Here you have all you need to setup oracle database with sysdba :

http://it.toolbox.com/wiki//index.php/Oracle:_Remote_Login_as_Sysdba


Best Regards
0
 
TOWELLRAuthor Commented:
I have found the solution.
For DBI:Oracle to connect as sysdba here is the string

my($dbh) = DBI->connect("dbi:Oracle:$site","$dbuser","$dbpass", { ora_session_mode => 2 });

You need to include { ora_session_mode => 2 } which sets the connect mode to sysdba.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now