Questions tagged [sysdba]
sysdba is an Oracle Database system privilege.
47
questions
1
vote
1
answer
30
views
TDE: Format of Data in Datafiles (.dbf files) with NUMBER and VARCHAR2 datatype
Nice to meet you all.
This is the first time I have posted here, so please feel free to let me know if I am wrong.
I am doing some research on the Transparent Data Encryption feature. I want to ...
- 13
0
votes
0
answers
50
views
Copying data from old column to new column with large amount of records
While updating/copying the data from old column to new column we are facing the issue with tablespaces in database.
Records count: 158 million+
Using below query to update the records,
UPDATE ...
0
votes
1
answer
538
views
Initial snapshot not yet available adding subscription issue
I am experiencing some issue with my subscription (transactional replication) recently as whenever I tried to add a new subscription to my existing publication either way I use Initialize when ...
0
votes
1
answer
182
views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
I am getting ORA-00942: table or view does not exist when tried to query the same.
- 13
0
votes
1
answer
89
views
Restricting Direct Changes in Database Data
Is it possible for Oracle database administrator to make direct changes in data contained in a row, for example, changing an amount of 50 to 500 either by typing into the database cell or by executing ...
- 3
0
votes
1
answer
358
views
Why is the SYS user granted both the DBA role and the SYSDBA privilege?
If the SYSDBA privilege gives the grantee ultimate authority, then why does the SYS user also have the DBA role in addition to the SYSDBA privilege?
- 131
0
votes
0
answers
85
views
Can a user connected as sysdba always bypass auditing mechanisms?
Can a user connected as sysdba always bypass auditing mechanisms? What could be done to minimize (or prevent) auditing prevention?
- 131
2
votes
0
answers
191
views
Resuming PostgreSQL logical replication (missing pg_stat_replication entry)
I implemented a logical replication on PostgreSQL 14 (from AWS to on-premise) via windows. A few days we experience internet lags. When i checked the pg_stat_replication in publication source, it was ...
1
vote
1
answer
219
views
My subdirectories under $ORACLE_HOME are missing
Im using oracle 11g. I cannot access the software products since they are missing. When I cd to $ORACLE_HOME, there are no files under it. They are missing. I cannot access the sqlplus. What to do in ...
- 11
0
votes
1
answer
664
views
How to we get history of sql statements of sysdba?
We have been running a list of commands in cli: sqlplus / as sysdba
We did not have "history on" and we logged out of the session. How do we get the list of sql statements we ran before as ...
1
vote
0
answers
885
views
high CPU usage of MySQL and recommendation from Mysqltunner [closed]
we have noticed that our database server is getting so high CPU (more than 90 % used by mysqld process), the output of mysqltunner is shown below, can you help me please,
i'm okay about the ...
- 123
0
votes
1
answer
28
views
Migration db (error when alter DB)
i am new as DBA. i want to migrate db, can i do one time alter for all data ?. or must one alter to one data ?
this my query.
DECLARE @name VARCHAR(50)
DECLARE db_cursor CURSOR FOR
SELECT name
FROM ...
0
votes
0
answers
281
views
What could be the cause of invalidation of "sys" views?
I had never experience anything like this but one of the scripts containing
select count(*) from user_tables where table_name = 'XXX';
started to throw
PL/SQL: ORA-04063: view "SYS.USER_TABLES&...
- 216
1
vote
0
answers
131
views
I (student) was encouraged to use SYSDBA and I broke my Oracle database. How do I fix it?
It all started when I tried to run catqm.sql as SYSDBA yesterday:
SQL> @?/rdbms/admin/catqm.sql xdb XML_DATA TEMP NO
Afterwards, I'd get this error whenever trying to execute DDL:
ORA-04098: ...
- 11
1
vote
1
answer
4k
views
How are the DBA, SYSDBA, SYSOPER roles and SYS, SYSTEM users related in Oracle?
I don't know if I correctly understand the privileges of these built-in roles and users, but this is a list of the information that I have found:
The DBA and SYSDBA roles enable you to do everything. ...
- 113
0
votes
2
answers
8k
views
ORA 01031 Insufficient privileges on GRANT SELECT on ALL_CATALOG to a user as system user
Command:
GRANT SELECT ON ALL_CATALOG TO appdbuser
*
Error:
ERROR at line 1:
ORA-01031: insufficient privileges
PROBLEM:
I want my Oracle XE system user (<-important) to be able ...
- 131
0
votes
1
answer
3k
views
ORA-01017: invalid username/password; cannot login with other users except sys user, Oracle Database 12c?
I have setup Oracle Database 12c on my local machine. It was working fine initially but now I cannot login to users' account except the sys user. I have altered users' passwords and tried logging in ...
- 103
0
votes
3
answers
2k
views
How can we clean up/backup of .DBF files in Oradata folder in ORACLE on windows
We have very less space on our C Drive where the DBF files are stored in windows server.
Can we clean up some space any logs can we removed on observation could see that DBF files are taking huge ...
1
vote
0
answers
45
views
SQL Server & Storage Question - What's the right choice? [duplicate]
I am a young DBA from Germany and I am the administrator for our customers SQL Servers.
I have a question and I really hope that I can explain this in English words. 😃
At the moment I am reading ...
1
vote
1
answer
27
views
re size datafile oracle
thanks for reading.
I am currently working with an Oracle 11G.I have a problem with a tablespace, I have very little space left, and I need to increase its capacity.I know what to do with this ...
- 125
0
votes
1
answer
177
views
SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')
I upgrade Oracle from 11.1.0.6.0 (32bit version) to 11.2.0.1.0 (64bit version) using RMAN on the same Windows computer (64bit).
After RMAN restored and recovered, I then try to run
SQL> startup ...
0
votes
1
answer
300
views
Are their any default privilege in Oracle for users?
I want to grant new users in Oracle the normal rules, for example, create a table, delete table update, in general, the default CRUD operations.
Every time I do this manually by running a grant script....
- 140
0
votes
1
answer
480
views
Where is my audit as Oracle sys audit is enable
On an Oracle 11gr1 database, SYS audit is enabled:
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ ------...
- 813
-1
votes
1
answer
2k
views
How to change the default database for login in T-SQL
I was trying to change the default database for logins in the sql server instance to the database they are mapped to. Currently, the default database of all logins in master database.
Alter login ...
- 133
1
vote
2
answers
42k
views
Retrieve user password in Oracle [closed]
How to obtain the password of a specified user in Oracle? What query to use to obtain that?
0
votes
1
answer
43
views
full model backup with tran logs
In a sql server database with a full model backup with tran logs backed up every 15 minutes, but ,still, the log file is huge. The backups (once a day) of the db and the tran log (every 15 minutes) ...
1
vote
2
answers
310
views
MySQL consuming a lot of CPU
I’m having trouble with a new server. I installed the optimized configuration for Ubuntu server with EasyEngine of VirtuBox.
When migrating my website with template newspaper, the CPU consumption is ...
- 19
0
votes
1
answer
3k
views
how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
- 13
0
votes
2
answers
715
views
TNS connection forward
There are 3 machines as follows:
Machine A - Remote Exadata DB machine
Machine B - Remote machine from which only I can connect to port 1521 of Machine A
Machine C - Local Machine (To run SQL ...
- 117
3
votes
1
answer
8k
views
What is an equivalent of EXCEPT(in PostgreSQL) in MySQL? [closed]
I want to find out unmatched records of two tables in MySQL.
- 41
2
votes
3
answers
9k
views
System account locked, insufficient privileges to log in as sysdba
I've researched the web but I could not found exactly the same situation than mine so I'm posting this message.
I'm connecting via Remote Desktop Connection to a remote server (Win2k3 Server). This ...
- 155
0
votes
1
answer
3k
views
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 ...
- 11
0
votes
1
answer
1k
views
SGA size vs SWAP space in Oracle RAC
I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I am aware that for 1-2GB RAM, swap has to be 1.5x. For between 2GB and 8GB, swap needs ...
1
vote
1
answer
143
views
Enabling MSSQL System Trace for DB Objects
I am trying to get changed recorded in MSSQL server for tables, view and stored procedures.
I have tried to achieve the same by right clicking on the server->Reports->standard reports->schema changes ...
- 11
1
vote
2
answers
313
views
Can `sys.aud$` recycle itself?
In Oracle 11, what happens if I leave sys.aud$ to get bloated up to soak up the whole SYSTEM TABLESPACE?
Does it start rewriting the oldest records? Can Oracle be configured to do so?
Does it stop ...
- 86
0
votes
1
answer
653
views
Where are SYS Audit Entries in Windows Event Log?
I have audit_sys_operations set to true, audit_trail set to DB, have restarted the database since setting them, and have logged in as and performed actions as sysdba. However, I cannot find these ...
- 305
2
votes
0
answers
9k
views
BCP Error SQLState = S1000, NativeError = 0 , Unable to open BCP host data-file
I am trying to execute the below BCP query in my TEST Server, where BCP has a connection string to the production DB, so my destination folder is in my Test Server and I am getting an error, I think ...
-3
votes
1
answer
1k
views
Query is still running
We have killed a specific query but still is running in background. How can we kill permanently. It's urgent.
Regards
Debajit
- 125
1
vote
1
answer
2k
views
I am facing issue while decryption (Gives NULL value), While export/Import my Colum level encrypted data
I am facing issue while decryption, Please help me if my column encryption/decryption process is wrong.
I encrypted table in Source DB and back up certificate, then exported my encrypted table result ...
6
votes
1
answer
1k
views
Avoiding Sysadmin Rights
I'm going to start off apologizing since this is my first post and looking at other questions they don't quite match my own situation, also I'm a SysAdmin, not a DBA so my understanding of SQL is ...
- 61
1
vote
1
answer
2k
views
Why all users excep sys and system can connect to oracle db after database deletion on multi database environment?
I have 2 database on one server.
I can connect to the database with normal users but cannot connect with sys and system users and invalid username/password occurs. before that I dropped one of the ...
0
votes
1
answer
11k
views
NLS_LANG AL32UTF8/UTF8 for Oracle database
I recently installed a new Oracle database on Ubuntu using this tutorial.
I got an error
oracle@ubuntu:/home/bruno$ echo $NLS_LANG
/u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh
oracle@ubuntu:/...
- 103
2
votes
5
answers
28k
views
How to Find SYS Privilege Users
I want to know which users have SYS and SYSDBA privilege before export/import operation.
I searched a lot but I could not find.
- 155
3
votes
2
answers
13k
views
how login other account by sysdba in oracle?
I forget hr's password, but I have sysdba role.
Can I use su hr like in linux.
I don't hope alter hr's password.
- 49
4
votes
1
answer
21k
views
Why doesn't "As SYSDBA" work from SQL Developer?
I am a SQL Server developer/DBA consultant who is helping out a customer who recently lost their Oracle DBA. I have done development on Oracle, but not much DBA work, and not in multi-homed ...
- 3,051
3
votes
1
answer
5k
views
How does the SYS user get the SYSDBA privilege?
I am using Oracle 12c on Linux. Using the enterprise manager database express, I am looking at the list of privileges and roles for the SYS user but I haven’t found the SYSDBA privilege assigned there....
- 285
10
votes
4
answers
194k
views
SYSDBA password in Oracle DB
I am connecting to Oracle DB with:
sqlplus / as sysdba
What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working ...
- 211