Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Connection
James,
I think you need something like +AS+SYSDBA in your connection string that takes this form.
user/password_at_MYDB+AS+SYSDBA
I saw this in a SQL script someplace but not at my fingertips.
hth
CS
"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.
>
> Hope someone can help!!
> cheers
> James
>
>
Received on Thu Mar 06 2003 - 08:45:08 CST