Questions tagged [oracle-21c]
Oracle database version 21c. Please also tag [oracle] for search purposes.
18 questions
0
votes
0
answers
18
views
How can I blob column values to files?
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 ...
- 175
0
votes
1
answer
80
views
Invoking DBMS_RESOURCE_MANAGER.CALIBRATE_IO in a PDB failing
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 ...
- 1,170
0
votes
0
answers
41
views
Cannot perform Windows authentication with Oracle DB
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 ...
- 1
0
votes
1
answer
647
views
Oracle 19c and 21c expdp exports dumpfile of 308kb without any content
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=...
- 1
1
vote
0
answers
58
views
Possible explanation for why "SELECT" query executed from JDBC returning just the first row in the table
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 ...
- 111
0
votes
0
answers
188
views
What’s wrong with provided apex instance administrator password
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 ...
0
votes
1
answer
2k
views
Set lsnrctl on Oracle XE 21C to listener.ora in file
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/...
1
vote
1
answer
4k
views
On Oracle 21c XE, what should ORACLE_HOME and TNS_ADMIN be set to?
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 ...
- 143
2
votes
1
answer
1k
views
Return a resultset as JSON text—using pretty formatting
In Oracle 21c, it looks like we can return a resultset as JSON text:
SELECT json_object(*)
from dual;
result:
{"DUMMY":"X"}
That works in db<>fiddle:
Question:
Is there a ...
- 1,527