Skip to main content
Database Administrators

Questions tagged [oracle-21c]

Ask Question

Oracle database version 21c. Please also tag [oracle] for search purposes.

18 questions
Newest Active Bountied Unanswered
0 votes
0 answers
18 views

I have a table defines as create table CO.PRODUCTS ( PRODUCT_ID NUMBER generated by default on null as identity constraint PRODUCTS_PK primary key, PRODUCT_NAME ...
Jin Kwon's user avatar
  • 175
0 votes
1 answer
394 views

I migrated from an on-premise Oracle XE to Amazon RDS. It's running on a T3.medium server with gp3 storage (200 GB/12000 IOPS). Almost every fifth minute the alert.log says like this: "Thread 1 ...
Björn's user avatar
  • 133
0 votes
1 answer
80 views

We have migrated a standalone Oracle database into an Oracle 21 multitenant database. We had run the DBMS_RESOURCE_MANAGER.CALIBRATE_IO package procedure in the source database prior to migrating the ...
Mark Stewart's user avatar
  • 1,170
0 votes
0 answers
162 views

There are 2 pluggable db's in the same container db running on Oracle 21c SE2 21.0.0.0.0 One pdb runs ORA$_ATSK_AUTOSTS every 15 minutes and it runs for less than a minute, seen from ...
crowne's user avatar
  • 125
0 votes
0 answers
44 views

I am trying to connect to my Oracle DB with Windows authentication, and it just doesn't seem to work - Whatever I do I keep getting "ORA-01017: invalid username/password; logon denied". I ...
hananku's user avatar
  • 1
0 votes
0 answers
103 views

I install Oracle 21c database and Oracle GoldaneGate 21.3 on Windows server, I can connect to my PDB using sqlplus and SqlDeveloper from another pc, but when try to dblogin from GGSCI get error this ...
sadegh's user avatar
  • 101
0 votes
1 answer
649 views

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
170 views

I have a big table with more than one hundred million records, it has this schema. schema of the table: CREATE TABLE USER_B.BIG_TABLE ( field1 NUMBER (10), field2 NUMBER(19,0), field3 ...
M_Gh's user avatar
  • 101
1 vote
0 answers
58 views

I installed OracleDB(XE - free version) and I tried to use it in Java. I have this code: static final String DB_URL = "jdbc:oracle:thin:@localhost:1521/XE"; static final String ...
Bogdan Floareș's user avatar
  • 111
2 votes
1 answer
1k views

Using this query: SELECT A.CACHE_BUFFER_TOTAL, B.CACHE_BUFFER_USED, A.CACHE_BUFFER_TOTAL - B.CACHE_BUFFER_USED AS CACHE_BUFFER_FREE FROM (SELECT BYTES / 1024 / 1024 ...
Isaac PM's user avatar
  • 23
0 votes
0 answers
188 views

1 I have installed Oracle Database 21c Enterprise Edition on Oracle windows 10 I am now trying to install Apex 22.2 . Got to the chapter "5.4.2.3 Running apxchpwd.sql" to set the instance ...
Prabhali Pawar's user avatar
  • 1
0 votes
1 answer
994 views

I installed Oracle Linux 21c on the remote machine, tested it in Linux shell, and it worked as expected (I can query the testing table I created). But I am stuck when trying to connect to the database ...
geopark's user avatar
  • 3
0 votes
1 answer
2k views

I installed Oracle XE 21C on an old laptop running Oracle Linux 8.6. I followed the official documentation without getting any errors. I am trying to set the lsnrctl to the one located in /opt/oracle/...
Smooth Researcher's user avatar
  • 1
0 votes
1 answer
73 views

We have a Java Spring boot application that writes 20 million plus rows in a table with 2 blob columns in a batched manner into an Oracle 21c DB. We are using JDBC batch insert for fast inserts. ...
humbleCoder's user avatar
  • 101
1 vote
1 answer
4k views

In my Windows Oracle 21c XE installation I have the product installed under: C:\Oracle\product\21c Below that there is: dbhomeXE which contains the bin directory and also network. However, I also ...
rghome's user avatar
  • 143

15 30 50 per page
1
2