Questions tagged [oracle-19c]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
84 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). I'm considering storing the query in a materialized view in order to improve performance and reduce the load ...
1
vote
0answers
54 views

How to improve Oracle Standard Edition's performance for testing? [closed]

There's a great post on StackOverflow about improving Postgres performance for testing. https://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940 However, ...
1
vote
1answer
82 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
85 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
28 views

Oracle database 19C moving back and forth with time without resetlogs [closed]

my client have a oracle database 19C on windows server 2016 for a business reason he need to be able to move back in time to specific date/time and modify some data and then move forth to the current ...
0
votes
0answers
21 views

Is it possible to select from procedure\function when the PDB is an argument without connect?

I have the following function in oracle 11g. Create or Replace function get_col_value( schema# in varchar2, table# in varchar2, column# in varchar2, rowid# in varchar2) Return varchar2 Is v_cmd ...
0
votes
1answer
73 views

Is it possible to give PDB name to a procedure and select from it?

The following example is not working, I just trying to show what I'm trying to do. Given table: -- this table is located at the CDB create table t1 (tab_name varchar2(35)) / -- this proc is located at ...
0
votes
1answer
46 views

How to select from pdbs with a cdb user?

I have several store procedures, which analyze oracle logs using log miner. These procedures run on CDB user C##ADMIN which created for this manner. Now I want to compare the logged values to the live ...
0
votes
0answers
55 views

Oracle 19c standby - redo transport errors

I have a 19c RAC Standby database on RHEL6 using dataguard, however, I’m currently getting a “ORA-16737 redo transport device dir standby has an error” msg. I’ve tried recreating the password file and ...
0
votes
0answers
34 views

SQL developer cannot connect to external databases. Only local ones

IO error: The Network Adapter could not establish the connection. Local databases work fine, but external one are returning me this error. I reinstalled once Oracle DV, and in the first time I ...
1
vote
2answers
81 views

Select failed from V$LOGMNR_CONTENTS when called from a procedure

Assuming the following user with these privileges granted: -- create admin user on CDB CREATE USER c##myadmin IDENTIFIED BY myadmin DEFAULT TABLESPACE system QUOTA UNLIMITED ON system ACCOUNT UNLOCK / ...
0
votes
1answer
74 views

How to quota a CDB only tablespace to a CDB user?

I can create a CDB tablespace like this: (all using: sqlplus / as sysdba) -- create unique table space for admin CREATE TABLESPACE admints DATAFILE '/path/to/admints.dbf' SIZE 20M AUTOEXTEND ON; I ...
0
votes
0answers
50 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
1answer
2k 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
15 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 ...
0
votes
1answer
387 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 ...
3
votes
1answer
59 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
0answers
97 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
67 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
0answers
174 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 ...
0
votes
2answers
1k 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 ...
0
votes
1answer
77 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
1answer
62 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
88 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
1answer
289 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
869 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
189 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
3k 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
64 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
75 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
4answers
1k 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 ...
1
vote
1answer
283 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
2k 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
61 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 ...
3
votes
1answer
7k 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....
2
votes
1answer
7k 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
90 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 ...
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
596 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 ...
1
vote
1answer
580 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 ...
0
votes
0answers
526 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 ...
0
votes
0answers
2k 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
0answers
2k 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
418 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
538 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
2k 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
75 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
2k 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
96 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
1answer
324 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 ...

1
2