Re: Oracle Connection

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 5 Mar 2003 23:26:40 +1000
Message-ID: <jKl9a.60793$jM5.155965@newsfeeds.bigpond.com>

"James" <james_at_nothing.com> wrote in message news:1046865162.279294_at_ftp.adept.co.za...
> Hi there
> Any help will be much appriciated!!
> If I connect to the database with administrator privleges, then start a
new
> instance and mount, but do not open the database.
> EG with the SQL Plus STARTUP MOUNT
>
> Can I after that creat a connection to the database using JDBC
> oracleConnection = DriverManager.getConnection
> (
> "jdbc:oracle:thin:@"+server+":"+port+":"+database,
> user,
> password
> );
>
> where I use the SYSTEM user and password both times? I know that mount
> startup only allows system administrators to have access.
>

Hi James,

With the database started in mount mode, you must have sysdba privileges to connect (good old system/manager will not suffice).

Cheers

Richard Received on Wed Mar 05 2003 - 07:26:40 CST