Stack Overflow
Stack Overflow

Questions tagged [oracle19c]

This tag is for questions which deal specifically with Oracle RDBMS version 19c. General question regarding the Oracle RDBMS product should use the `oracle` tag.

This tag is for questions which deal specifically with Oracle RDBMS version 19c. General question regarding the Oracle RDBMS product should use the oracle tag.

898 questions
21
votes
2 answers

Hibernate Dialect for Oracle 19

One of our database was upgraded to Oracle 19c and now my application is unable to connect to database I am getting the following error. HHH000400: Using dialect: org.hibernate.dialect.Oracle12cDialect HHH000342: Could not obtain connection to…
NullPointerException
  • 3,732
  • 5
  • 28
  • 62
8
votes
6 answers

how to install oracle database express on mac m1

I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle database. I tried to install using docker and OrcaleVM but both attempt were unsuccessfull.…
Jay Sabnis
  • 101
  • 1
  • 1
  • 3
8
votes
4 answers

\[INS-30014] Unable to check whether the location specified is on CFS

On migrating my local Oracle DB on Windows, from 11g to 19c, while running the setup.exe, I got a: [INS-30014] Unable to check whether the location specified is on CFS
Jonathan Lalou
  • 234
  • 1
  • 2
  • 6
6
votes
2 answers

How to fix the read only error on lima vm

Getting read only file system error when try to create local repository for docker. [1] I used this installed lima [2] over Macbook Air M1 (Apple chipset) chown: changing ownership of 'oracle-19c/.DS_Store': Read-only file system chown: changing…
Achala Kumarai
  • 61
  • 1
  • 2
6
votes
1 answer

Initial extent size when converting to partitioned table

Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table. Since Oracle12, alter table modify partition has been available to convert non-partitioned tables to partitioned tables. I have a…
jparker
  • 63
  • 5
6
votes
1 answer

How to forbid using the same table alias twice in a query?

I am running Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0. Consider the following example: create table tab_a as select 1 as id from dual union all select 2 as id from dual union all select 3 as…
Arnoldo
  • 73
  • 4
5
votes
1 answer

How to get the quarter corresponding to a date in Oracle SQL 19c

I think there was a function extract(quarter from date) in oracle sql to fetch the quarter for a given date. However the Oracle SQL 19c documentation here does not show the presence of quarter anymore. I even tried running the code - select…
Anirban Chakraborty
  • 539
  • 1
  • 5
  • 15
5
votes
1 answer

Can two transactions modify the same row at the same time in Oracle?

What happens if two transactions try to modify the same row simultaneously? Normally, once the row is modified, the other transaction waits until the first one performs commit or rollback. But what if they send the update requests exactly at the…
oramas
  • 881
  • 7
  • 12
5
votes
2 answers

Can we use System.Data.OracleClient in .Net against Oracle 19c?

so we migrated Oracle 12.2 to 19c and the Asp.Net app that connects to oracle service is now failing with the following error: Oracle 12560: TNS Protocol Adapter Error before anything, I'd like to confirm that the .net dll System.Data.OracleClient…
user12762335
  • 51
  • 2
5
votes
1 answer

Couldn't determine Dialect for "oracle"

I am using Spring boot(2.3.5), Oracle19c DB, and Hibernate(5.4). I tried to make multi-datasource connection, but I keep getting a dialect error Couldn't determine Dialect for "oracle". Error creating bean with name 'jdbcDialect' defined in class…
Eniss
  • 975
  • 2
  • 20
  • 40
5
votes
1 answer

How to Register Pluggable Database(PDB) with new created LISTENER

I am working with Oracle 19c in centos 7. After Oracle installation, i created new Container Database(CDB) with Plugguble Database(PDB) using DBCA. I am working with port number=1522 [oracle@ol8-19 ~]$ lsnrctl start LISTENER_TST LSNRCTL for Linux:…
K.D.Gayan
  • 143
  • 1
  • 1
  • 10
5
votes
1 answer

SQL Developer doesn't display XML

Oracle's SQL Developer doesn't display the content of XML columns when the datatype XMLType is used. The first lines are displayed ok (if Preferences > Database > Advanced > Display XML Value in Grid is ticked), but once you doubleclick on the…
wolφi
  • 8,091
  • 2
  • 35
  • 64
4
votes
1 answer

Why there are both filter and access predicates on the same index on this execution plan?

Considering the execution plan for this query : SQL_ID 1m5r644say02b, child number 0 ------------------------------------- select * from hr.employees where department_id = 80 intersect select * from hr.employees where first_name like 'A%' Plan…
oramas
  • 881
  • 7
  • 12
4
votes
1 answer

What is the DBMS_Crypto.encrypt() equivalent of DBMS_Obfuscation_Toolkit.DES3Encrypt()?

I am editing some Oracle code that includes DBMS_Obfuscation_Toolkit references. I read that the DBMS_Obfuscation_Toolkit package is de-supported as of Oracle 10.2, and that I should upgrade my code to instead be use DMBS_Crypto. I have this…
Jeromy French
  • 11,812
  • 19
  • 76
  • 129
4
votes
1 answer

Spring JPA slow query with Oracle using like and upper

I encounter an optimisation problem and I can't figure out why my query is so slow. In production when searching for document.name the application takes about 4 minutes when there are no results and without IDX_DOC_NAME_UPPER. With…
Burl21
  • 41
  • 3
1
2 3
…
59 60