Oracle & DBI connection issue - without password 1

[RogersJ]

I've just upgraded my Oracle database from 8.0.6.3 to 9.2.0.5

This connection used to work with Oracle 8 but doesn't work with 9.

  my $dbh = DBI->connect "dbi:Oracle:", "internal", " ",
            {PrintError => 0, AutoCommit => 0, 
            ora_session_mode => 2} ) ;

The user running the job, is identified externally to the database.

The internal user was deprecated with Oracle 9.

I have a requirement that I can not put hard coded userids and passwords in script files, nor pass them in on the command line.

Any help with connecting without a password would be appreciated.

Thanks
Jan

 

[PaulTEG]

I have a requirement that I can not put hard coded userids and passwords in script files, nor pass them in on the command line.

How else do you percieve passing passwords to external systems, USB Key, CD...

Can you include them in include files.

The password above is a single space, try "" instead.

--Paul

 

[RogersJ]

With scripts that connect to the database, I use externally identified users. Restricting access to objects within the database.

Resolution to my problem is:

my $dbh = DBI->connect("dbi:Oracle:", "[COLOR=red]/ as sysdba[/color]", " ",
          {PrintError => 0, AutoCommit => 0, ora_session_mode => 2} )
          or die "our$ora_errnum $ora_errstr";

Incidentally, if you make the password "" instead of " " you get an ORA-01017: invalid username/password in this example.


Jan