Questions tagged [oracle-19c]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
36 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
43 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
12 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
42 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
18 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
13 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
32 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
  • 116
0 votes
1 answer
17 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
70 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
57 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
87 views

How do I launch sql script on every pdb using catcon with a SPECIFIC USER?

I need to launch some pl/sql on all pdbs in a cdb, loggin in as a specific user which doesn't exist on the cdb$root. I thought I could use the catcon perl script, but I tried in different ways and I ...
trustno1's user avatar
0 votes
1 answer
209 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
42 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
62 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
122 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
424 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
226 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
74 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
57 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
746 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
16 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
147 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
59 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
138 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
284 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
  • 54
0 votes
0 answers
48 views

I am having trouble creating a listner in Oracle 19C. Some help will be appreciated

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
  • 54
0 votes
0 answers
15 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
51 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
  • 506
2 votes
1 answer
131 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
360 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
620 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
85 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
0 votes
0 answers
52 views

after restroring tablespace table or view not exists

I've Oracle CDB with PDB In the PDB I created a tablespace then I created a table over this tablespace after that, I login into RMAN for the CDB database then I make a backup using backup database ; ...
Tariq Hajeer's user avatar
2 votes
0 answers
136 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
862 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
0 votes
1 answer
113 views

Cardinality miscalculations leads to ridiculous execution plans

I'm not talking about stale statistics, or just simply "bad"/"non-optimal" plans. We have a lot of complicated queries running in our database. Normally all works as expected. But ...
Andy DB Analyst's user avatar
2 votes
1 answer
220 views

DISTINCT gives duplicate values

Can it be considered a bug? This query gives duplicate values despite DISTINCT: select distinct '1' from ( select * from dual connect by level <= 10 ) order by dbms_random.value fetch first 10 ...
Andy DB Analyst's user avatar
0 votes
1 answer
38 views

how many processes nmuber should I put for 6 employee in Oracle 19c

I have homework to create an Oracle database. so there's a requirement that 6 employees are allowed to enter the database. How many processes should I put in while creating the database for 6 ...
Tariq Hajeer's user avatar
0 votes
1 answer
165 views

Slow count on empty table unexplained

My incremental materialized view refresh starting to become slower and slower. Each day there are millions of new records. So there are many deletes on the mv log table. After investigation I see one ...
Nir's user avatar
  • 513
0 votes
1 answer
137 views

What could be the cause of the ORA-12638 error when setting up Oracle Data Guard?

I'm configuring Oracle Data Guard and I'm experiencing ORA-12638. I have the Oracle 19c database on a Windows Server 2019. In the DR site, I can connect to the primary with no problem. But connecting ...
Poco Ocop's user avatar
0 votes
0 answers
96 views

Top reasons for temp tablespace to go offline

It was marked offline and it is fixed already. We want to know the list of causes that marks the temp tablespace offline.
Suresh Dooly's user avatar
1 vote
2 answers
167 views

how to audit users with old password versions

I must set SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a on all of my database servers. How can I check if clients still use old authentication protocols? I know I can check DBA_USERS for old password ...
elfcheg's user avatar
  • 163
0 votes
0 answers
65 views

DBA_TAB_MODIFICATIONS out of whack in Oracle when moving partition or subpartition segments

I've observed that when moving a partition or subpartition of a table (ALTER TABLE xyz MOVE PARTITION abc), the row count of the moved segment gets reflected in DBA_TAB_MODIFICATIONS at higher levels (...
Paul W's user avatar
  • 578
1 vote
1 answer
108 views

[[FATAL]] [[DBT-06103]] The port (5,500) is already in use in Docker Container

I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error [FATAL] [DBT-06103] The port (5,500) is already in use. ACTION: ...
Vishwanath Joshi's user avatar
0 votes
1 answer
31 views

Should I model statistical summary as a separate entity or with the summarized entity as part of the key

I run several tests on each unit on a wafer and want to store a summary (median, cpk, std dev, etc) of the results for each test across the wafer. I also want to store a summary of the results for ...
Chris94's user avatar
  • 101
0 votes
1 answer
199 views

Oracle trigger is fired more times then expected

I'm working on the job which updates using the next SQL UPDATE (SELECT a.column_1, TO_NUMBER(SUBSTR(b.column_3, 1, 5)) new_column_1, FROM table_2 b INNER JOIN ...
S8S's user avatar
  • 1
0 votes
0 answers
331 views

ORA-12034 while doing a COMPLETE refresh

Trying to understand how it's possible to get ORA-12034 while doing a COMPLETE refresh? Oracle 19.18.0.0.0 All the documentation/notes/metalink indicates this is an error for FAST refresh mat views, ...
Ditto's user avatar
  • 506