Questions tagged [sysdba]
45 questions
30
votes
5 answers
DataGrip: how to connect to Oracle as SYSDBA
I tried to setup in DataGrip an Oracle connection under SYS user.
But got error:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
But there is no option in GUI to choose as SYSDBA option.
Vadzim
- 24,954
- 11
- 143
- 151
15
votes
2 answers
How to recover or change Oracle sysdba password
We are working with an oracle database in which the person that set it up is "long gone" and thus do not know the sysdba password, but need it. We have root access to the box (its on linux). Is there any way to recover or change the sys passwords?
Adam Lerman
- 3,369
- 9
- 42
- 53
6
votes
1 answer
grant permission for dbms_crypto
I am using dbms_crypto.encrypt function in my oracle procedure for encryption of passwords. I have connected to oracle as :
connect sqlplus as sysdba
and then granted permission as :
grant execute on sys.dbms_crypto to myuser;
And then i can use…
Andrew
- 3,632
- 24
- 64
- 113
5
votes
2 answers
Why many tables ORACLE default 12c?
Creating a new database (basic and advanced), It's my first time dealing with Oracle, in which I do not know why so many tables, triggers, views and other objects when only wanted to create a relational data base empty.
Is there another way to do…
1antares1
- 1,146
- 2
- 11
- 19
5
votes
1 answer
Getting "java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER" in groovy
Code is as follows -
import groovy.sql.Sql
def driver = "oracle.jdbc.OracleDriver"
def jdbcUrl = "jdbc:oracle:thin@myhost:1521:MYSID"
def sql = Sql.newInstance(jdbcUrl , "sys", "password", driver)
But I am getting following error
Caught:…
Aniket Thakur
- 66,731
- 38
- 279
- 289
3
votes
2 answers
Why can my new user login as sysdba in oracle?
I just installed Oracle 11g R2 on windows 7 machine. I am able to login using my sys as sysdba account.
Using the sys account I created a user as follows
create user testuser identified by testuser;
When I try to connect to database with testuser…
Ankur
- 151
- 1
- 3
- 5
3
votes
1 answer
java.lang.SecurityException: policy table update SYS:JAVA.LANG.RUNTIMEPERMISSION, GETCLASSLOADER
While trying to grant java execute permissions to my schema ABC from sys, i get the below error.I tried various versions but every time i get the error, any suggestions.
I'm using Oracle 12c Database
SQL> BEGIN
DBMS_JAVA.GRANT_PERMISSION…
826dna
- 163
- 3
- 11
3
votes
3 answers
Can't login as sysdba in oracle sqlplus
'hello
I am trying to login locally installed oracle 11g database from my windows machine using
system / as sysdba
Its asking for username and password , but In my knowledge its using default windows account and will login without any prompt .…
Bodhi
- 548
- 4
- 14
- 26
3
votes
5 answers
How can I connect to an Oracle database as SYS using an ADO connection string?
I am trying this:
Provider=MSDASQL.1;Persist Security Info=False;User ID=sys;Password=pwd;Initial Catalog=DATABASE;Data Source=OdbcDataSource;DBA Privilege=SYSDBA
But I get the error:
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr…
JosephStyons
- 57,317
- 63
- 160
- 234
3
votes
2 answers
Running Oracle IMP as SYSDBA
I need to import an ORACLE 9 DMP file into a newly installed Oracle 11g. I'm using the imp utility and using SYSMAN as the login. I get to the point to restore and am told 'only a DBA can import a file exported by another DBA'. When I try and use…
Bob Perkins
- 31
- 1
- 1
- 2
2
votes
1 answer
Can a non sysdba compile dbms_session?
I am trying to use sys.dbms_session.set_context in one of my stored procedures, but I am getting the following error:
ORA-01031: insufficient privileges
My issue is that I cannot use it in my stored procedure, however...I am getting the same error…
jonesy19
- 139
- 1
- 16
2
votes
2 answers
Execute sql statement as sys as sysdba
I have a sql statement executed in a script which connects to sqlplus and execute some GRANTS statements. In the bash script the instruction is something like:
sqlplus sys as sysdba @script.sql
but I need to add the password. How can I do in a…
Ernest Poldrige
- 399
- 1
- 6
- 17
2
votes
1 answer
Django Oracle connection as SYS should be as SYSDBA or SYSOPER
I'm trying to use Oracle Database for Django. Oracle DB is active and I can connect with SQLDeveloper. But cannot connect from Django to Oracle DB.
I got this error:
django.db.utils.DatabaseError: ORA-28009: connection as SYS should be as SYSDBA or…
Zulfugar Ismayilzadeh
- 2,643
- 3
- 16
- 26
2
votes
3 answers
Keeping SYSDBA connection open in C++
Problem: I am trying to connect as "SYSDBA" and then create a user in my C++ application. The connection to SYSDBA seems to close before running the create command.
I am trying to run the following two commands:
CONNECT…
Kyle Williamson
- 2,251
- 6
- 43
- 75
1
vote
2 answers
how to specify DBA role while connecting to Oracle DB from a spring boot application
I am creating a spring boot application which is connecting to an Oracle DB instance.My application is required to process SQL commands like CREATE PLUGGABLE DATABASE,ALTER PLUGGABLE DATABASE,ALTER SESSION,CREATE TABLESPACE,ALTER USER etc.
My…
sdv
- 21
- 1
- 3