Questions tagged [sysdba]

sysdba is an Oracle Database system privilege.

Filter by
Sorted by
Tagged with
0
votes
0answers
47 views

Oracle Apex: catcon::wait_for_completion: unexpected error in next_proc()

I am trying to install oracle apex 19.2 on Oracle 18C XE edition . But while installing I am getting below error message after running @apexins.sql sysaux sysaux temp /i/ catcon::wait_for_completion:...
1
vote
1answer
18 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 ...
0
votes
1answer
59 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
1answer
46 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....
0
votes
1answer
71 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 ------------------------------------ ------...
-1
votes
1answer
486 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 ...
0
votes
2answers
9k 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
1answer
36 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
2answers
155 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 ...
0
votes
1answer
883 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
0
votes
2answers
471 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 ...
3
votes
1answer
7k views

What is an equivalent of EXCEPT(in PostgreSQL) in MySQL? [closed]

I want to find out unmatched records of two tables in MySQL.
1
vote
3answers
6k 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
699 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
1answer
133 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 ...
1
vote
2answers
192 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 ...
0
votes
1answer
462 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 ...
2
votes
0answers
4k 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
1answer
743 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
0
votes
1answer
595 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
1answer
488 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 ...
1
vote
1answer
704 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
1answer
6k 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:/...
1
vote
3answers
15k 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.
3
votes
2answers
6k 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.
4
votes
1answer
17k 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 ...