Questions tagged [oracle-19c]
Oracle Database 19c. Please also tag oracle for search purposes
47
questions
0
votes
0answers
12 views
Why does json_equal use so much PGA memory and how to avoid it?
I have an Oracle 19c database and a schema with two tables (let's call them L and R). They have the same structure: Two VARCHAR2 columns I'll call T and J. The second one has an IS JSON STRICT ...
0
votes
0answers
9 views
What does a NULL last_executed column mean in the Oracle data dictionary table sql_plan_baselines?
Using Oracle DBMS 19c on Windows server. The static data dictionary view DBA_SQL_PLAN_BASELINES has a lot of rows (over 160k) and I'm trying to figure out why. The vast majority have a LAST_EXECUTED ...
3
votes
1answer
45 views
Ordering CONNECT BY siblings
I have an hierarchical query that uses CONNECT BY:
select
wonum,
parent,
classification,
classstructureid,
division,
worktype,
status,
glaccount,
fircode,
...
0
votes
1answer
24 views
ora-03114 not connected to oracle
Since the upgrade to the 19C Oracle DB (before 12C) I receive randomly those ORA-03114 error message's.
Before the upgrade I never received it. Any idea's what exactly why those error messages pops up ...
0
votes
0answers
27 views
Oracle writes to SSD drive are really slow
My customer recently ported their database to a new server that has an SSD drive.
This new server uses Windows 2016 Server OS, and the SSD drive model is a DELL PERC H740P Mini
The good news is the ...
0
votes
1answer
26 views
IMPDP Job Failing with ORA-54002
I am trying to import a dump file from an 11g database into a 19c database instance. I am running the job as SYSTEM as recommended by Oracle. The job starts but quickly devolves into failing SQL ...
0
votes
1answer
22 views
logon denied for oracle wallet user
Following a video tutorial on oracle wallets: https://youtu.be/LLZzUNb9ALU
The db server is run from oracle's official docker container.
The steps I have done are as follows:
On server shell, ran sql ...
0
votes
2answers
37 views
Report based on MV: Deliberately make the report fail if MV is out of date?
I have a query that is used in a BIRT report (in IBM's Maximo Asset Management platform).
--report name: 'work order cost summary report' (more info here: https://codereview.stackexchange.com/q/251785/...
0
votes
1answer
25 views
Migrating data from 11G Linux to 19C on Windows
I'm using datapump to move data from 11.2.0.4 on Linux to 19C on Windows. It seems to be working except for some objects in the system schemas. Is there any reason to bring these schemas across or can ...
0
votes
0answers
19 views
Oracle Database Vault: Changing DV Owner and DV Account-Manager passwords hangs PX Deq: Execute Reply/row cache lock
When changing the password of the users mentioned above the sessions hangs. And it seems to be a deadlock. When changing the password it seems that two sessions are spawned:
Blocking session
C##...
0
votes
1answer
25 views
Oracle 19c Standard Edition RPM installation
I'm wondering if it's possible to install Oracle Standard Edition from RPM, not Enterprise Edition. It's possible to choose edition when you do 'runInstaller', is it possible to set some parameter ...
0
votes
0answers
24 views
Oracle 19c express manager not loading, listener will not register https port after exec dbms_xdb_config.gethttpsport()
We just set up a new oracle 19c install on a VM Windows Server 2020. I have been struggling trying to get the Express Manager working. At the end of the installation Oracle notified me that I can ...
1
vote
1answer
46 views
Why am I able to create MV logs using PK — even though there is no PK?
I have a table that does not have a primary key:
I'm able to create MV logs on the table — without specifying whether to use the primary key or the rowid:
create materialized view log on maximo....
0
votes
1answer
35 views
Materialized view logs — with condition?
I've created materialized view logs on a WORKORDER table in an Oracle 19c database.
create materialized view log on my_workorder_system.workorder with rowid;
The plan is to integrate the WORKORDER ...
0
votes
1answer
54 views
ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test
I have trying to execute a simple test with jmeter in Oracle 19.7 database. This is my lang configuration in database
SQL> select * from nls_database_parameters;
...
NLS_NCHAR_CHARACTERSET ...
0
votes
1answer
57 views
Materialized view not purging (over dblink via view)
I've created a materialized view between a primary system (Oracle 18c) and an external system (Oracle 19c):
create materialized view primary_system.workorder_mv
build immediate
refresh force
on ...
0
votes
0answers
70 views
Oracle - Set Object to NonEditionable
I am having an issue with Editioning in an Oracle 19c database. I have never heard of this feature before today, but I have found that somehow a number of objects in the database have had their ...
2
votes
3answers
140 views
Oracle allows inserting into table even after revoking quota
I am studying creating users and granting roles and I have come across this scenario where I grant unlimited quota to a user, insert into the table and then revoke the quota. I expected that after ...
1
vote
1answer
235 views
Error “RMAN-04006: error from auxiliary database” in the middle of duplicate executiion
I'm trying to create a standby database with duplicate command.
Primary : tntdb19
Standby : mntdb19
The duplicate command begins but fails after some time
[oracle@monta191 admin]$ rman target sys/...
0
votes
0answers
33 views
Why Oracle 19c generating error while installation?
I am trying to install Oracle 19c Enterprise Edition.I am using Windows 10 Home.For any additional required information please tell me in comments.
1
vote
0answers
59 views
Reduce file header block
I'm in the middle of my first Statspack analysis, and one of the most time consuming events is Buffer Busy Waits (around 30% time). I checked out the Buffer Wait statistics, and it seems like the most ...
0
votes
1answer
263 views
Why Oracle 19c Database EM Express Webpage is not opening in Microsoft Edge?
I have recently installed Oracle Database 19c on my Laptop which has Windows 10 OS. Now, I want to open the localhost:5500/em page in Microsoft Edge browser, but when I try to do so, the webpage does ...
0
votes
4answers
222 views
What privileges do I need to change the password of sys in an Oracle Database?
Our identity management tool wants to change the sys password regularly. It fails with the ORA-01031. What privileges or roles do I need to grant the identity management tool user to be able to change ...
0
votes
2answers
135 views
Error 0xc000007b with Oracle 19c
As our (32-bit) application uses the Oracle client for communication with the Oracle server I have set up a test environment on a Microsoft Windows Server 2019 Datacenter. I have installed the Oracle ...
1
vote
1answer
92 views
Oracle: Inserting into table error - either duplicate column name or invalid datatype
I'm trying to insert data from an external table.
INSERT /*+ ignore_row_on_dupkey_index ( consruct ( construct_id ) ) */
INTO construct
(construct_id,
n_term ,
enz_name,
...
1
vote
2answers
488 views
Can an Oracle 19c database dblink to an Oracle 10.2.3 database?
I have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database.
I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3).
Will my dblinks to the Oracle 10.2.0.3.0 database ...
1
vote
1answer
26 views
ORACLE DB Connects only when I do not specify SID
I have an Oracle 19c database in a Unix server.
SQLPLUS command connects only when I do not specify the SID.
sqlplus system/manager
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 20 12:37:30 ...
2
votes
1answer
2k views
UTL_FILE directory name changes oracle 19c
I've scripts where UTL_FILE.FOPEN is used and the parameter passing for directory is an absolute path i.e., /asr/file/path and the corresponding oracle directory name as ASR_ABC but after up-gradation ...
1
vote
2answers
45 views
Column name on NOT NULL constaint violation not shown
I'm using an Oracle 19 DB that is structured into multiple layers by using DB users. Here is a simplified overview of the structure:
User DATA: Has the table XTEST and the view TEST. The view is ...
2
votes
1answer
2k views
Oracle 19c database instance doesn't register with listener
I have just installed an oracle 19c (19.3.0.0.0 to be exact) database on a centOS 8 virtual machine. The databases instances can all be started with sqlplus on the host machine. I have set up listener....
0
votes
0answers
25 views
autonomous database in two regions
Backgroup on the autonomous database
For the last couple of years Oracle have offered a "autonomous" or "self driving" database in their cloud which is only available on the Oracle cloud. If you ...
0
votes
1answer
137 views
What permissions are required for complex cross-schema materialized view in Oracle?
I have a complex cross-schema query that I'd like to create as a materialized view in Oracle 19c (although the database has been ported forward from numerous historical versions of Oracle). This ...
0
votes
0answers
19 views
How to restart an installation of Oracle grid 19c
I would like to know how to perform an installation after trying a previous installation that gave an error.
During the installation of the grid in a RAC 19c I was given an error almost finishing it ...
0
votes
0answers
221 views
ORA-12560: TNS:protocol adapter error in Windows 10
Listener and service are up and running. In SQL Plus, if I connect with no login, and execute 'conn sys/pwd@host:port/sid as sysdba', connection is established successfully. But if I connect / as ...
1
vote
1answer
688 views
Oracle19C installation is stuck at executing datapatch in Windows 10 using dbca
I tried using dbca. There are no errors. It just hangs. I tried leaving it running for 4 hours. It is always stuck at 36% even after multiple tries.
Logs:
[progressPage.flowWorker] [ 2020-05-25 00:...
0
votes
0answers
940 views
Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation
Oracle 19c installation fails with this error message.
I am trying to set up oracle for my 'Existing Local User' account
Installation logs tries to add Admin user to all groups and fails .it says ...
1
vote
1answer
302 views
About real time statistics oracle 19c only for particular table
Reg Real-Time statistics which extends online statistics gathering(12c) to also include conventional DML statements.
Real-time statistics helps the optimizer generate more optimal plans.Whereas bulk ...
1
vote
0answers
916 views
19c Impdp hangs after SCHEMA_EXPORT/VIEW/VIEW with cpu 100%
I've a impdp job on Oracle 19c always hanging with 100% CPU (ora_dw00_orclcd process) after the message below:
Elaborazione dell'object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Elaborazione dell'object ...
0
votes
1answer
102 views
Oracle 19c Installer Can't Select National Character Set
I am trying to install a new 19c instance of Oracle database in order to migrate a 12c database there. The 12c database uses a database character set of WE8ISO8859P1 and a national character set of ...
1
vote
1answer
134 views
Grant rights to create a table with an identity column on another schema
I have a user in charge of deploying DDL on other schemas than its own.
This user can create a table on those schemas, it can also create sequences on those schemas.
But when I try to create a table ...
0
votes
0answers
685 views
EM Express page of Oracle 19c is not opening
I have setup the https port for EM express in the CDB database:
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500)
However while opening the EM express page https://hostname:5500/em/ the browser is throwing "...
1
vote
2answers
70 views
Oracle newly created DB is filled with datatables
I've just created my first database with oracle database configuration assistant.
Basically nothing special, database was created successfully. What I don't understand is why are there so many tables ...
0
votes
2answers
537 views
TNS-12543: TNS:destination host unreachable
I have a installed oracle 19c
but i am unable to login
Please refer the following screen shot
I am not unable to login
which user credential require to login
1
vote
1answer
61 views
How to list all users that have a specific Temporary Tablespace like as default
I'd like how list all users that have a specific Temporary Tablespace Default.
0
votes
0answers
25 views
Access all the containers with a common user
I created a pluggable database
CREATE PLUGGABLE DATABASE testpdb2 ADMIN USER admin2 IDENTIFIED BY dbpasswd2
FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/pdbseed', '/opt/oracle/oradata/ORCLCDB/...
2
votes
1answer
3k views
Migrated DB from 12c to 19c with IMPDP failed
I have migrated a DB from 12c to 19c with IMPDP and EXPDP. While importing I have seen some errors. Below is an extract of the errors.
Errors During Import
Processing object type SCHEMA_EXPORT/TABLE/...
0
votes
1answer
128 views
What privileges are need for a normal Oracle user to access V$ and DBA_ views?
I'm connecting to Oracle 19c as HR user. I want to execute the following SQL and some dba_... views:
select s.sid
,s.serial#
,s.username
,s.machine
,s.status
,s.lockwait
...
