Stack Overflow
Stack Overflow

Questions tagged [sysdba]

45 questions
1
vote
1 answer

Firebird/Interbase - create new user/view without SYSDBA

I'm developing app that need data from Firebird DB. Guy that create this DB forgot SYSDBA password and I need create new user or just view. Other apps that communicate with DB have also unknown users. But I can connect to the DB server so I see DB…
m45k1c
  • 9
  • 4
1
vote
1 answer

How do I migrate DB as SYSDBA in Maven Flyway Plugin?

I am using the Maven Flyway plugin to migrate a database in Oracle. Unfortunately, in the flyway:clean phase for Schema1, the synonym I created for Schema1 to Schema2 is lost. The workaround I considered is migrating the database as user "sys" and…
honorableruler
  • 79
  • 1
  • 8
1
vote
1 answer

connecting as SYSDBA using roundhouse

I want to connect as sysdba using roundhouse, already tried conn.ConnectionString = "Driver={Microsoft ODBC for Oracle};SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CON NECT_DATA=(SERVICE_NAME=orcl)));uid=scott;pwd=tiger**;as…
user009
  • 11
  • 1
0
votes
1 answer

Using Ansible how to connect Oracle DB on Linux & run command "show pdb" to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB

Using Ansible how to connect Oracle DB on Linux Machine to use commands "show pdb" to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB. please guide. I have tried below code which will copy oracle home path from /etc/oratab…
Learner
  • 13
  • 4
0
votes
1 answer

How do i connect to database using 'sqlplus / as sysdba' rather than 'sqlplus sys/ as sysdba'?

username/password less connectivity to oracle database. i tried to add "SQLNET.AUTHENTICATION_SERVICES=none" in /dbs/sqlnet.ora location.
JEI
  • 1
  • 1
0
votes
1 answer

Oracle - unable to create DB link

I am unable to create the DB link as it's throwing ORA - 01031 insufficient privileges error. Let's say I have database DB1 and schema name as s1 and second database as DB2 with schema t1. I am trying to create the DB link by sysdba user by running…
RAHUL SONI
  • 59
  • 1
  • 7
0
votes
1 answer

Reg: sysdba not logging, system user and other user connecting

Sysdba not logging other users are logging below, how to fix it, able to login to other users successfully, please find below, only with sysdba not working [oracle@dztupbin]$ ./sqlplus SYSTEM/"oracle" SQL*Plus: Release 12.2.0.1.0…
luck_26
  • 7
  • 4
0
votes
0 answers

Grant DBA role to a user in cloud

I logged in as admin and issued grant statement to another user Grant dba to user; I got the error DBA role does not exist or the role was not granted. I require this since I am trying to import a table from my local database to cloud database. I am…
Nisha R
  • 1
0
votes
2 answers

Changing SYSDBA user password in InterBase

I am working with InterBase 2020 version. Since InterBase installs with default user SYSDBA and default password for SYSDBA as masterkey , I want to change the password for SYSDBA user. Using gsec tool I am able to change the password however when I…
Deepak kumar jain
  • 115
  • 1
  • 10
0
votes
2 answers

Ora-01031: insufficient privileges when I create the first user

I tried to create a user after creating tablespaces but there is an error at line 1, ORA-01031: insufficient privileges. This is what I wrote and the effect ... Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 12c…
Korotsoane Ntoi Justice
  • 1
  • 1
0
votes
1 answer

How can I change/create the sysdba password for firebird 3.0 embedded

How can I change or set the SYSBDA password for a firebird 3.0 embedded database. I don't/can't want use the local or default authentication.
kaiserilich
  • 3
  • 2
0
votes
1 answer

regarding oracle database "sysdba" user and creating a new user

I am very much new to oracle database, please forgive me for any technical errors in my question. I am using oracle 19c and I think my password for "system" user is different than the password for "sysdba". At the time of installation I used the…
gkd
  • 11
  • 6
0
votes
0 answers

Oracle 12c pluggable database won't start

After running some scripts to install/uninstall Oracle Application Express (APEX), now my pluggable database won't start. I get the (uninformative) error: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fetched column value is NULL I…
Howard007
  • 124
  • 7
0
votes
1 answer

RMAN online full backup without archivelogs

I need to take oracle database full backup (online) which is in archivelog mode. My current archive redo log partition space is very less, so i backup and delete archived redo log files then and there to manage the space. My question if i take rman…
knkarthick24
  • 3,106
  • 15
  • 21
0
votes
1 answer

ORA-01031: insufficient privileges while connecting with sys as sysdba

I installed Oracle database 10g as an administrator on a windows 10 machine, it worked fine, but when i try to connect sys as sysdba it gives me the error: ORA-01031: insufficient privileges I checked sqlnet.ora file and if …
zenami
  • 131
  • 2
  • 10
  • 23
1
2
3