iansane
August 22nd, 2010, 03:49 AM
Hi,
I recently installed oracle-xe on my Ubuntu 10.04.
It took me the longest time to figure out how to log in because every how to I found said just do "sqlplus sys as sysdba".
Well, that doesn't work. I noticed after a restart that there is a new oracle user so I tried that and it works. The problem is, when I'm logged in as me and I want to use sqlplus, I have to do "su oracle" before I start.
This is not a big deal at the moment and I'm sure it's good security but what do I do when I want to write a program that uses the db? I mean I already created a new user in the db but that user can only log into sqlplus through the new Ubuntu oracle user account.
I added my account to the dba group but that didn't change anything.
Any suggestions?
Thanks
I recently installed oracle-xe on my Ubuntu 10.04.
It took me the longest time to figure out how to log in because every how to I found said just do "sqlplus sys as sysdba".
Well, that doesn't work. I noticed after a restart that there is a new oracle user so I tried that and it works. The problem is, when I'm logged in as me and I want to use sqlplus, I have to do "su oracle" before I start.
This is not a big deal at the moment and I'm sure it's good security but what do I do when I want to write a program that uses the db? I mean I already created a new user in the db but that user can only log into sqlplus through the new Ubuntu oracle user account.
I added my account to the dba group but that didn't change anything.
Any suggestions?
Thanks