Skip to main content

Questions tagged [oracle-19c]

Oracle Database 19c. Please also tag oracle for search purposes

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

How have other DBAs gotten around the lack of Oracle documentation for installing Oracle 19c on Red Hat Linux 9 without using ASMLib?

For one of our applications, we are trying to stack validate running our application on RHEL9 and Oracle19c. We currently use RHEL7 and ASMLib, but ASMLib is not currently available for RHEL9. We don'...
ArgeeSix's user avatar
0 votes
0 answers
15 views

oracle 19c user getting EXPIRED & LOCKED within several minutes when all password related settings in its profile are set to unlimited

I cannot understand why the account in Oracle 19c NON-CDB database getting locked few minutes later after creation. Audit trail is not configured. I'm running the database in container, it's Oracle ...
bezraznizi's user avatar
0 votes
0 answers
15 views

Rotate encryption key for asm tde wallet oracle 19c

I have 1 database that has the tde encryption wallet located in ASM rather than o/s I now need to rotate the encryption key. I normally do this by changing the key ob one node then copying to the ...
anne scott's user avatar
0 votes
0 answers
43 views

ORA-65139: Mismatch Between XML Metadata File And Data File

I have two systems - SYS1, SYS2(stand alone). On both is running an oracle 19c database. I want to create a plugable database from SYS1 and want to plug in the SYS2 database. I created the pluggable ...
ca2510fl's user avatar
0 votes
1 answer
31 views

Compressing partitioned tables in Oracle 19c

I am compressing partitioned tables. before partitioned tables, I tried normal tables with the follwoing steps: DBMS_REDEFINITION.START_REDEF_TABLE( uname => 'USER', orig_table => '...
datascinalyst's user avatar
0 votes
1 answer
30 views

Oracle temporary tablespace performance

I'm looking for ways to improve my database performance for heavy analytical queries and found that my temp tablespace has 1M extents (default for uniform tablespace). With my usual temp tablespace ...
Andy DB Analyst's user avatar
0 votes
0 answers
54 views

Oracle Data Pump Export (expdp) how to exit if invalid credentials and not wait to provide valid one?

Execution: Export: Release 19.0.0.0.0 - Production on Thu May 9 07:58:59 2024 Version 19.20.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDE-01017: operation ...
Jakub P's user avatar
  • 157
1 vote
2 answers
73 views

Oracle SQL query slow even with indexes

I have an Oracle 19c database (19.0.0.0.0), and two tables with lots of columns, I'll mention only the relevant ones: table1: createtime date contact_key char(96 byte) table2: contact_key char(96 ...
Gábor Major's user avatar
0 votes
0 answers
65 views

Facing cyptographic checksum error

I am randomly however very very frequently facing the following error while running query from pro*c. Pro*C is running on the same Linux as the Oracle DB so network should not be an issue. SQL Code [-...
pOrinG's user avatar
  • 125
1 vote
1 answer
31 views

Tryting to export data from one table but got error

I'm new to database export/import stuffs (as I'm not DBA), and I'm recently tasked to develop a housekeeping script which include the export data pump (expdp) subtask. But for some reasons, when I run ...
NEET UI's user avatar
  • 11
0 votes
0 answers
29 views

Create an index at oracle sql server on tablespace

I want to create an index of type context on a tablespace different from the one the table is. Also I want to pass parameters. The data type of ATTACH_BIN is BLOB. CREATE INDEX ATT_INDEX ON ...
Nick's user avatar
  • 1
0 votes
0 answers
45 views

Issues with v$archived_log - Oracle 19c

I have a standby database, on which I executed the command: alter database recover managed standby database cancel and it was executed successfully - The complication I am facing is: When I execute: ...
datascinalyst's user avatar
0 votes
1 answer
222 views

RMAN: restore not done; all files read only, offline, excluded, or already restored

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server. This is the backupscript BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT '...
datascinalyst's user avatar
0 votes
1 answer
31 views

Migration of Data Guard HW Servers to Cloud Servers

I'm looking for information & advice on the best way to migrate from a hardware Oracle 19c Data Guard server pair to an Oracle 19c Cloud Data Guard server pair. Our configurations currently are: ...
P_J's user avatar
  • 1
0 votes
1 answer
130 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

Trying to export schema using the following command on several Oracle instances: two 19c and one 21c $ expdp mySchema/myPwd@ORCL Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=...
Vy8's user avatar
  • 1
0 votes
0 answers
391 views

How can I check the current memory management mode for an oracle database instance?

I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
Eric Swiggum's user avatar
0 votes
0 answers
15 views

How to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC?

What are the different ways to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC on Azure VMs?
Sunil Bopanna's user avatar
0 votes
1 answer
463 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

I want to create a script to get incremental backup of the remote Oracle database every week. I save this command in rman_command.sh and give permission to it: BACKUP INCREMENTAL LEVEL 0 DATABASE ...
M_Gh's user avatar
  • 101
0 votes
0 answers
37 views

RMAN ERROR: BACKUP command not found

I have an Oracle database 19c with IP, x.x.x.a that have a lot of important tables. I want to get backup of that and save it on another system with IP,x.x.x.b. I did this actions on the x.x.x.b system:...
M_Gh's user avatar
  • 101
0 votes
0 answers
70 views

How to fix high px deq slave session stats in Oracle RDS

We are seeing some high percentage of "px deq slave session stats" waits in our Production database.(this maintained on AWS RDS). Due to which outage is happening many times from searching ...
Arun's user avatar
  • 13
0 votes
1 answer
92 views

Duplicating from active database fails at connection

I'm trying to duplicate a database from active database, but it seems like my connection is blocked on my auxiliary. I'm using ASM just4info. Target DB: listener.ora: LISTENER = (DESCRIPTION_LIST = ...
paganini's user avatar
  • 118
0 votes
1 answer
26 views

Oracle returns invalid number of rows on json_table

When I run following query on Oracle 19, it returns 27 record instead of 30, and I cannot understand why, as I am expecting 30 records: select * from json_table('{"values":[[1,120674124,...
Amir Pashazadeh's user avatar
1 vote
0 answers
24 views

dblogin cannot connect to SYSTEM DSN

I'm trying to install golden 19.1.0.0 on Window Server. I try to connect to SQL Server 2019 with dblogin and got the error in the picture. Any idea how to solve it?
KhoiNguyen's user avatar
0 votes
1 answer
109 views

oracle pdb Relocation to new server

We plan to migrate the data (8 PDBS with at least 50 TB Data) of our old oracle server 19c to the new one (same version) and we must do this task with minimal or no downtime. For this reason we can ...
TimLer's user avatar
  • 161
0 votes
0 answers
159 views

Oracle latch:shared pool waits causes application disconnection

I'm in need of help regarding some very weird behaviour on 1 of my production Oracle 19c database. This database was upgraded from 11g some time ago & after the upgrades the applications had been ...
Jason Oon's user avatar
0 votes
1 answer
696 views

Connection rejected based on ACL filtering, but the ACL is disabled?

I'm trying to connect to an Oracle Cloud database through DataGrip (with JetBrains's instructions) but I'm getting an error: DBMS: Oracle (no ver.) Case sensitivity: plain=mixed, delimited=exact [...
andyinnie's user avatar
0 votes
0 answers
53 views

oracle disconnect sometime

Oracle sql version is 19c. I have encountered one issue that Oracle sql sometime will disconnect and then auto connect. How can I find the cause? To get error, so write below. try { OracleConnection } ...
Jun's user avatar
  • 1
1 vote
1 answer
135 views

oracle 19c rac cluster nodes show in different time zones

working on an oracle 19c 2-node rac cluster. we were running awr reports when we noted in sys.dba_hist_snapshot that the cluster nodes were in different time zones. We have validated that our ...
2ps's user avatar
  • 113
1 vote
1 answer
283 views

RMAN backup restoration

I am trying to restore a RMAN backup to a different server. I needed some clarifications/guidance. This is the location for datafiles in database 1: /u01/app/oracle/oradata/db1/datafile This is the ...
datascinalyst's user avatar
0 votes
1 answer
1k views

we can connect sqlplus / as sysdba but get error ORA-01034: ORACLE not available

i have errror when connect with sqlplus / as sysdba, but i can connect sqlplus sys/oracle@db as sysdba, could you give me advise regarding this problem,, [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: ...
DIQ_DUN's user avatar
1 vote
1 answer
543 views

Oracle SELECT FOR UPDATE on a single row with ORDER BY: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc

I have a control table and want to be able to select for update a single row in this control table. However, using an ORDER BY and WHERE rownum = 1 along with a FOR UPDATE results in ORA-02014: cannot ...
Matthew Moisen's user avatar
0 votes
1 answer
145 views

19c database suddenly using CBO on a certain query

We have had a performance problem on a particular APEX screen, ever since we had to perform a Dataguard failover 10 days ago. I'd put it down to general system load until I investigated more deeply ...
Carlovski's user avatar
  • 113
1 vote
1 answer
89 views

Wrong cardinality estimation after gathering statistics ORACLE

We have a large table range partitioned by month. Incremental statistics turned on. After scheduled statistics gathering cardinality estimation become weird, like select count(*) from my_table where ...
Andy DB Analyst's user avatar
0 votes
1 answer
2k views

ORA-19914: unable to encrypt backup and ORA-28365: wallet is not open

I have been taking backup of my database daily, and for some reason, I suddenly got this error ORA-19914: unable to encrypt backup ORA-28365: wallet is not open this is my databases's current ...
datascinalyst's user avatar
0 votes
0 answers
19 views

Restoring PDBs on a new server

I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
datascinalyst's user avatar
0 votes
0 answers
255 views

How to restore backup of Oracle Database unto same server where original database is running (and not allowed to shutdown original database)

I'm using RMAN, it's Oracle 19c and non-CDB (stand-alone). The problem is that the restored database has to have a different name, since the original database is already running on that server. ...
baffy's user avatar
  • 1
2 votes
0 answers
85 views

Can I audit all actions of a database role?

I know from AskTom that we can audit all actions of a particular user account, e.g.: create audit policy test_audit_policy actions all when q'!sys_context('userenv', 'session_user') = '...
Thorsten Kettner's user avatar
1 vote
0 answers
25 views

Can I actively renounce roles given to me?

I am a database developer. Over the many years working in the same company I have been granted many database roles. Many more than I should actually have. I know I could make a list of the roles I don'...
Thorsten Kettner's user avatar
0 votes
1 answer
435 views

Oracle DB - can it run without JDK, JRE that is installed together with?

Our client is scanning for outdated JDKs or JREs and found those in Oracle DB instance files, installed files. Is it safe for Oracle DB to remove JDK, JRE? Name="Java(TM) SE Runtime Environment&...
Jakub P's user avatar
  • 157
0 votes
2 answers
609 views

Unable to connect to Oracle user in pluggable database

for some reason, i am unable to connect with any user that I create. their account status is also unlocked. I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
dbafix's user avatar
  • 62
0 votes
0 answers
55 views

I am having trouble creating a listener in Oracle 19C

These are my active services: SQL> SELECT NAME FROM V$ACTIVE_SERVICES; NAME ---------------------------------------------------------------- pdb3 orcldb pdb2 pdb1 and this is my listener.ora ...
dbafix's user avatar
  • 62
0 votes
0 answers
18 views

utl_tcp fetch exact length of response

I am using utl_tcp to connect to an external service and return some data. All is fine until I get to this line: utl_tcp.get_text(c, 100) The issue with this is the call waits for the timeout I have ...
SkinnyPete63's user avatar
1 vote
0 answers
13 views

Why am I getting a privilege error when creating a table from a trigger in Oracle? [duplicate]

I'm trying to create a trigger that creates a backup of a table before it is truncated. However, I'm getting a permission error when attempting to create a new table. Why? create or replace trigger ...
Matt's user avatar
  • 111
0 votes
1 answer
69 views

sql92_security rolling recycle ? or full reboot?

Changing sql92_security parameter requires database to be recycled. This much is clear. However, I'm wondering if a rolling recycle is enough? or does this parameter require a full blown DB stop/start ...
Ditto's user avatar
  • 504
2 votes
1 answer
282 views

In Oracle Enterprise 19c, is there a way of finding what procedure is executing a commit?

I have a loop in a procedure which calls a number of other procedures. At the end of the loop, it does a commit. However, based on the results I am seeing it appears it is doing a commit on each ...
Paul Stearns's user avatar
0 votes
1 answer
977 views

Index rebuild, on a busy table, in a 24/7 system

We have got an audit table, that has got pretty big (> 1 billion rows). It's got a number of indexes that are actually bigger than the table itself, that are the ideal case for index key ...
Carlovski's user avatar
  • 113
0 votes
2 answers
1k views

Oracle 19c SYS user locked

Not sure how it happened, but somehow my SYS user in my local Oracle 19c database got locked. When I try to log in, I get a "ORA-28000: The account is locked." error. I tried querying ...
Jyclop's user avatar
  • 101
0 votes
0 answers
124 views

How do I duplicate/copy a database from one user to another on the same host?

I have a oracle se2 database and I want to duplicate a database do a different user in the same host (for testing data migration stuff). I created the user and gave it all the privileges required, but ...
daniel's user avatar
  • 1
2 votes
0 answers
185 views

Oracle 19C Auto Compile fails on Package With SQL_Macro but ALTER PACKAGE ... COMPILE Succeeds

We have a package SCHEMA.MYPACKAGE with a procedure SCHEMA.MYPACKAGE.GETDATA that calls a sql macro SCHEMA.SQLMACROFUNCTION that exists within the same schema but outside the package. The macro is ...
lightwing's user avatar
0 votes
1 answer
1k views

ORA-32771: Cannot Add File To Bigfile Tablespace

I have 1TB tablespace that have one bigfile , The disk size now full and added extra disk to my server but there is no way to expand Drive that bigfile in it , so need to add another bigfile ,if ...
FarshiD Naqizadeh's user avatar