Questions tagged [oracle-19c]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
65 views

Issues installing Oracle Database 19c on Windows 10 [closed]

I am running into all sorts of issues while trying to install Oracle Database 19c on my personal Windows 10 machine. I downloaded the newest version from Oracle's website and need a subject matter ...
0
votes
1answer
65 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
62 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
0answers
23 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 ...
2
votes
1answer
88 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
76 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
20 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
393 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
40 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 ...
1
vote
1answer
455 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
40 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
14 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
86 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
214 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
375 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
193 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
464 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
39 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
81 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
310 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
68 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
331 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
52 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
21 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
2k 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
98 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 ...