I have a quick question relating to Oracle TDE. Could somebody please explain why both of the following pairs of commands appear to work when opening/closing an ecryption wallet? Is the wallet password actually needed for this or not? If not, when exactly do we need to use the password? Many thanks. administer key management set keystore close identified by ""; administer key management set keystore open identified by ""; administer key management set keystore close identified by "null"; administer key management set keystore open identified by "null";

I'm trying to connect to an Oracle Cloud database through DataGrip (with JetBrains's instructions) but I'm getting an error:

DBMS: Oracle (no ver.)
Case sensitivity: plain=mixed, delimited=exact
 ORA-12506: TNS:listener rejected connection based on service ACL filtering.

However, clearly the ACL is disabled: What could possibly be causing this error and how can I fix it.

We have provided sql tuning set as input to the analysis task of performance analyzer

variable l_task_id VARCHAR2(64);

exec :l_task_id:=dbms_sqlpa.create_analysis_task(
     sqlset_name => ''
    , sqlset_owner=>''
    ,task_name => '');

Now i want to list all the tasks associated with the sql tuning set. I have tried below ways but they are not working

select parameter_name,parameter_value 
from dba_advisor_exec_parameters 
where task_name='' and parameter_name='SQLSET_NAME';

But the result is showing "NOT USED" for column parameter_value |parameter_name | parameter_value| |-------------------- | ------------------| |SQLSET_NAME UNUSED||

**This question concerns Oracle PL/SQL (Oracle version 12c/19c) and Oracle SQL Developer (version 20.4).** I have a procedure which calls a dynamically generated SELECT statement and save results into sys_refcursor. I would like to print content of the refcursor within the procedure and show it in ouput window of Oracle SQL Developer. So far, I was able to only return the refcursor from procedure through OUT parameter and bind variable, and then print it. My current code of the procedure looks like this:

create or replace procedure cursor_show (rc_out OUT sys_refcursor) is
    v_sql           varchar2(1000);      
    v_rc            sys_refcursor;
begin           
    --other statements generating SELECT 
    v_sql := 'select ...'; --my SELECT
    
    open v_rc for v_sql; --get data 
    rc_out := v_rc; --return refcursor
end;

To print results, I need to call these statements:

var x refcursor;
execute cursor_show (:x);
print x;

I would like to encapsulate print into procedure cursor_show to get something like this:

create or replace procedure cursor_show is
    v_sql           varchar2(1000);      
    v_rc            sys_refcursor;
begin            
    --other statements generating SELECT 
    v_sql := 'select ...'; --my SELECT
    
    open v_rc for v_sql; --get data 

    print v_rc; --print data
end;

After that, I would be able to call the procedure and print the refcursor content with one-row statement execute cursor_show;. However, once I tried to compile such procedure, I received this error message:

Error(51,11): PLS-00103: Encountered the symbol "V_RC" when 
expecting one of the following: := . ( @ % ; 
The symbol ":=" was substituted for "V_RC" to continue.

Could you please advise how to call print statement within body of the procedure?

I'd like to know if there is a way to get the DML (insert, delete) SQL of uncommitted statements in Oracle 19c in my own session? For example, if I have typed some statements and I haven't committed them and I've closed my worksheet, can I get them back? Another example of this. Say I've done some deletes using the SQL Developer GUI, selecting the rows I want to delete and then clicking the delete icon (without haven't committed nor made a rollback yet). Is there a way I can get this as SQL statements? I thought I could get them in the *Log* but no... Surely there has to be a way but I haven't found it. Can you help me out?

I am setting up online and archived redo shipping from a source database (PRIMARY) to destination database (PRIMARY). I cannot use a STANDBY database as destination as I have to setup real time downstream capture using Oracle XStream and standby databases are READ only. The issue I am facing is once I setup both DBs following instructions from here and here , I am able to receive the archived redo log files (I see the files showing up after a log switch). But, I am not receiving online redo log files, which is required for real time capture. Anyone setup this and maybe help with what might be missing? Please note that if I switch the destination DB from PRIMARY to STANDBY I receive both online and archived redo log files, but it doesn't serve my purpose. I am using the simple remote login password mode to communicate between the two DBs.

I am running Oracle Enterprise Manager 13c (Version 13.5). The binary for OMS EMCTL had got corrupted displaying 0 bytes. To mitigate this issue, I installed EMCTL on a different location on the same server and copied the binaries to the original middleware binary location. However, when running the emctl utility I am greeted with "No OMS is found to be associated with the current Oracle Home". Have done all the internet recommendations from setting environmental variables, to changing the properties files (./sysman/config/emInstanceMapping.properties).

A vendor application we're using utilizes multiple _processes_ (not threads) spread across multiple computers, one for each processing core available. When asked for a batch of calculations, the application distributes the load between these engines, which then go to the database for additional details necessary to perform the computations. As we add more cores -- and engines -- the simultaneous rush to the database causes a load spike so big, some engines start getting the ORA-12170: TNS:Connect timeout occurred error, which causes them to crash (I know, it shouldn't, but we cannot fix the vendor's code). For example, with the engine-count of 1386, about 300 engines dump cores, because the 16-core Oracle server cannot cope... There is no official way to cause the application to _stagger_ these engine-initializations... But the first thing each engine is doing is invoke the same stored procedure -- which updates the same table -- and I'm wondering, if I can alter it to perform the staggering: cause each engine to _sleep_ for random number of milliseconds. What would the SQL snippet for this look like? Our servers run Oracle-19...

We're maintaining a "hairy" vendor-supplied application, which sometimes forgets to drop its temporary tables. Years ago we've created a simple script to get rid of all of them after the application-instance is shut down:

BEGIN
                for rec in (select table_name
                    from user_tables
                    where table_name like 'R%#%#%_TMP')
                loop
                        execute immediate 'drop table '|| rec.table_name;
                end loop;
        END;

Lately this script started throwing errors occasionally, one of these two: * ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired * ORA-00942: table or view does not exist It seems, something is competing with the script trying to drop the same tables, but there shouldn't be anything -- the application in question is already shut down. Could it be, the application's own request to drop these tables is, actually, _deferred_ by Oracle -- and is acted upon later, when our own script tries to delete them too? Currently using Oracle Database 19c Enterprise Edition 19.0.0.0.0, with master->slave replication enabled.

It seems that I cannot connect via tns alias on my auxiliary, I know I could bypass it by either connection locally with auxiliary e.g. auxiliary / or adding a (UR=A) parameter. The DB is in nomount. I want to know why, because I have explicitly created two static listener registrations, to use it for the dataguard and for the duplicate, but I have following issue. Here is firstly the configuration. listner.ora [oracle@server-salzburg admin]$ cat /u01/app/19/grid/network/admin/listener.ora #Backup file is /u01/app/oracle/crsdata/server-salzburg/output/listener.ora.bak.server-salzburg.oracle line added by Agent # listener.ora Network Configuration File: /u01/app/19/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server-salzburg)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=graz_DGMGRL) (SID_NAME=graz) (ORACLE_HOME=/u01/app/oracle/product/19/dbhome_1) ) (SID_DESC= (GLOBAL_DBNAME=salzburg_DGMGRL) (SID_NAME=salzburg) (ORACLE_HOME=/u01/app/oracle/product/19/dbhome_1) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent tnsnames.ora [oracle@server-salzburg admin]$ cat tnsnames.ora SALZBURG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server-salzburg)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = salzburg) ) ) graz_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server-graz)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = graz) ) ) salzburg_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server-salzburg)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = salzburg) ) ) listener output [oracle@server-salzburg admin]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-JUN-2025 20:27:36 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 09-JUN-2025 20:24:03 Uptime 0 days 0 hr. 3 min. 33 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19/grid/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/server-salzburg/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server-salzburg)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "+ASM_DG_DATA" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "+ASM_DG_FRA" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "graz_DGMGRL" has 1 instance(s). Instance "graz", status UNKNOWN, has 1 handler(s) for this service... Service "salzburg" has 1 instance(s). Instance "salzburg", status BLOCKED, has 1 handler(s) for this service... Service "salzburg_DGMGRL" has 1 instance(s). Instance "salzburg", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully rman error: [oracle@server-salzburg admin]$ rman target sys/*******@graz_DGMGRL auxiliary sys/******@salzburg_DGMGRL Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jun 9 20:28:00 2025 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: GRAZ (DBID=3282927897) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

community! I have a table with three SecureFile LOBs in it (lets name them A, B, C) and I want to compress them. At first I wanted to do it in three parts, every time moving and compressing one specific LOB. I tried the following command:

alter table MYTABLE
move lob (A) store as (compress)
online
parallel 4;

It looks like ORACLE not only compresses and moves LOB A, but also it moves B and C! I decided this from the space consumption: there are three new temporary segments, two of which are getting close to the original LOB sizes. Is it true that ALTER TABLE MOVE command implicitly moves all the LOBS within the table? Can I split my work in three parts or should I go with one alter table move lob(A) lob (B) [...] lob (N) command? My Oracle version is 19c.

I have two columns in an Oracle 19c db

C1
a,b,c,d
x,y,z

C2
1,2,3,4
1,2,3

I want to make a select query which will return one column like this:

C12
a1,
b2,
c3,
d4,
x1,
y2,
z3

I`m not able to use any for loop. Values from C1 are always equal with C2, delimiter is always ',' and can be N values in this columns. Thank you for you time. OR > select 'TOTAL EUR, USD, EUR' as c1,'300,120,200' as c2 from dual; > > > >

> C1                  | C2         
> :------------------ | :----------
> TOTAL EUR, USD, EUR | 300,120,200
> 

> select 'TOTAL EUR 300'||chr(10)||'USD 120'||chr(10)||'EUR 200' as c12 from dual; > >

> | C12                                 |
> | :---------------------------------- |
> | TOTAL EUR 300
>   USD 120
>   EUR 200 
> 

*dbfiddle [here](https://dbfiddle.uk/?rdbms=oracle_18&fiddle=e0765226bd68f4cb8a8e4e234687eb80)*

I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error

[FATAL] [DBT-06103] The port (5,500) is already in use.
   ACTION: Specify a free port.

I referred this answer https://dba.stackexchange.com/questions/268437/fatal-dbt-06103-the-port-5-500-is-already-in-use?newreg=335276877b8c4859a5fd41263b960125 but how to achieve this in container where hostname is always dynamic.

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server. This is the backupscript

BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT 'Prod_Full_DB_%u_%s_%p' DATABASE plus archivelog;

When I completed the restore, I faced this error

SQL> RECOVER DATABASE;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 8922136743 generated at 03/24/2024 04:19:33 needed for thread
1
ORA-00289: suggestion : /u03/archives/1_65472_1115909325.dbf
ORA-00280: change 8922136743 for thread 1 is in sequence #65472


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/u03/archives/1_65472_1115909325.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

I solved this error by manually transferring the archives to the server. I also realized that the archive which was causing problem was made DURING the backup process. After the restore was completed I did some searching, and found a way to restore archives from the backup pieces:

run {
allocate channel t1 type disk;
set archivelog destination to '/u04/';
restore archivelog until sequence 65460;
release channel t1;
}

however, I am facing this error

archived log for thread 1 with sequence 1 is already on disk as file /u01/archives/1_1_1164473680.dbf
archived log for thread 1 with sequence 2 is already on disk as file /u01/archives/1_2_1164473680.dbf
restore not done; all files read only, offline, excluded, or already restored

**I guess this might be because the database has already been restored.** any changes I should make when I am taking the backup, as the archive which was causing an issue, was made while the backup was being taken.

I'm trying to migrate a simple MySQL test database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the tables are empty and i receive the following error "ORA-00942 table or view does not exist". 2023-01-25T08:52:10.649730400Z 730400 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.convert.ConverterWorker Eseguito il coalesce del catalogo MySQL, schema test nello schema singolo test Convert.COALESCED oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle MySQL test test oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:11.575035900Z 35900 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.core.util.MultiLevelLogManager Colonna 'number' modificato in 'number_' (Caratteri non validi, parola riservata o conflitto) oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:14.770235800Z 235800 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.workbench.core.ui.FullMigrateTask Conversione completata in 0 secondi oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:20.872501Z 501000 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle SEVERE oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil Generation phase ORA-00942: tabella o vista inesistente oracle.dbtools.metadata.persistence.PersistableObject.doUpdate(PersistableObject.java:364) oracle.dbtools.metadata.persistence.PersistableObject.save(PersistableObject.java:186) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doGenerate(FullMigrateTask.java:1303) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:437) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:321) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:154) oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199) java.base/java.util.concurrent.FutureTask.run(Unknown Source) oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702) java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) java.base/java.util.concurrent.FutureTask.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source) oracle.dbtools.migration.workbench.core.logging.LogInfo@15963e4b oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Generation phase ORA-00942: tabella o vista inesistente oracle.dbtools.metadata.persistence.PersistableObject 364 oracle.dbtools.metadata.persistence.PersistableObject 186 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 1303 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 437 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 321 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 154 oracle.dbtools.raptor.backgroundTask.RaptorTask 199 java.util.concurrent.FutureTask oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask 702 java.util.concurrent.Executors$RunnableAdapter java.util.concurrent.FutureTask java.util.concurrent.ThreadPoolExecutor java.util.concurrent.ThreadPoolExecutor$Worker java.lang.Thread 2023-01-25T08:52:20.877506400Z 506400 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle WARNING oracle.dbtools.migration.workbench.core.ui.FullMigrateTask L'esecuzione dello script generato include errori: FAILED : Migrazione del database : FAILED oracle.dbtools.migration.workbench.core.logging.LogInfo@2b459c32 MySQL queries: CREATE DATABASE test /*!40100 COLLATE 'utf8_general_ci' */; CREATE TABLE test ( number INT(11) NULL DEFAULT NULL, string VARCHAR(50) NULL DEFAULT NULL ) ENGINE=InnoDB; INSERT INTO test.test (number, string) VALUES ('1', 'test'); INSERT INTO test.test (number, string) VALUES ('2', 'test'); This is the master.sql generated from the wizard: SET ECHO ON SET VERIFY ON SET FEEDBACK ON SET DEFINE ON CLEAR SCREEN set serveroutput on COLUMN date_time NEW_VAL filename noprint; SELECT to_char(systimestamp,'yyyy-mm-dd_hh24-mi-ssxff') date_time FROM DUAL; spool "Test5_&filename..log" -- Password file execution @passworddefinition.sql PROMPT Dropping Role ROLE_Test5 ... DROP ROLE ROLE_Test5 ; PROMPT Creating Role ROLE_Test5 ... CREATE ROLE ROLE_Test5 ; -- PROMPT Drop test user -- drop user test cascade; PROMPT Create user test CREATE USER test IDENTIFIED BY &&test_password PASSWORD EXPIRE ACCOUNT LOCK /* DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP */; GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM, UNLIMITED TABLESPACE TO test; -- PROMPT Drop Emulation user -- drop user Emulation cascade; PROMPT Create user Emulation CREATE USER Emulation IDENTIFIED BY &&Emulation_password PASSWORD EXPIRE ACCOUNT LOCK /* DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP */; GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM, UNLIMITED TABLESPACE TO Emulation; set define on prompt connecting to Emulation alter session set current_schema=Emulation; set define off set define on prompt connecting to test alter session set current_schema=test; set define off -- DROP TABLE test CASCADE CONSTRAINTS; PROMPT Creating Table test ... CREATE TABLE test ( number_ NUMBER(10,0), string VARCHAR2(50 CHAR) ); GRANT ALL ON test TO ROLE_Test5; set define on prompt connecting to test alter session set current_schema=test; set define off spool off; COMMIT; I've also tryied to create the user and grant unlimited quota on all the table_spaces but the result is the same. Anyone have an idea of what could be the problem?

I am trying to create a pluggable database using a response file, but it is giving me the error below, indicating that one of the mandatory parameters is missing. Although I have checked it multiple times, I don't see that any missing mandatory parameter. Below is my response file which I am using. dbca -silent -createPluggableDatabase -responseFile /f01/app/oracle/dbca_pdb_creation.rsp [INS-04008] Invalid combination of arguments passed from the command line. One or more mandatory dependent arguments are not passed for the argument: -create pluggable database I am able to create the database when passing the required parameters directly in command line as below: dbca -silent -createPluggableDatabase -sourceDB testcdb -pdbName testpdb2 -createPDBFrom default -pdbAdminUserName PDBADMIN -pdbAdminPassword abcd1234 **Response file** ############################################################################## ## ## ## DBCA response file ## ## ------------------ ## ## Copyright(c) Oracle Corporation 1998,2019. All rights reserved. ## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ############################################################################## #------------------------------------------------------------------------------- # Do not change the following system-generated value. #------------------------------------------------------------------------------- #----------------------------------------------------------------------------- # GENERAL section is required for all types of database creations. #----------------------------------------------------------------------------- [GENERAL] #----------------------------------------------------------------------------- # Name : RESPONSEFILE_VERSION # Datatype : String # Description : Version of the database to create # Valid values : "12.1.0" # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0 #----------------------------------------------------------------------------- # Name : OPERATION_TYPE # Datatype : String # Description : Type of operation # Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase" \ "deletePluggableDatabase" \ "configurePluggableDatabase" # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- OPERATION_TYPE = "createPluggableDatabase" #-----------------------*** End of GENERAL section ***------------------------ #---------------------------------------------------------------------------------- # CREATEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "createPluggableDatabase". #---------------------------------------------------------------------------------- [CREATEPLUGGABLEDATABASE] #---------------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "testcdb" #---------------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : The name of new pluggable database # This pdb name must not be same as sourcedb name. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- PDBNAME = "testpdb2" #---------------------------------------------------------------------------------- # Name : CREATEASCLONE # Datatype : Boolean # Description : specify true or false for PDB to be create as Clone. # : When "true" is passed a new PDB GUID is generated for the plugged in PDB # Default value : true # Mandatory : NO #----------------------------------------------------------------------------- CREATEASCLONE = "TRUE" #---------------------------------------------------------------------------------- # Name : CREATEPDBFROM # Datatype : String # Description : specify the source of pdb to be plugged # Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML # Default value : DEFAULT # Mandatory : NO #----------------------------------------------------------------------------- CREATEPDBFROM = "DEFAULT" #---------------------------------------------------------------------------------- # Name : PDBADMINUSERNAME # Datatype : String # Description : PDB Administrator user name # Default value : None # Mandatory : Mandatory only when creating new DEFAULT PDB #----------------------------------------------------------------------------- PDBADMINUSERNAME = "PDBADMIN" #---------------------------------------------------------------------------------- # Name : PDBADMINPASSWORD # Datatype : String # Description : PDB Administrator user password # Default value : None # Mandatory : Mandatory only when creating new DEFAULT PDB #----------------------------------------------------------------------------- PDBADMINPASSWORD = "abcd1234" #-----------------------*** End of createPluggableDatabase section ***------------------------ Please help.

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 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Mon Jul 20 2020 11:45:41 +05:30

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

However, when I try with the SID, it does not connect.

sqlplus system/manager@S19110

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 20 12:40:01 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed


Enter user-name:

I see the following in my listener.log :

TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe

I googled the error and tried the following troubleshooting methods but no help. 1. 6751 permission for $ORACLE_HOME/bin/oracle 2. Increase max number of processes in the database. Please help.

I'm designing a property management database that will hold - OWNER, CUSTOMER, and STAFF information. As these use many of the same attributes, I intend to create tables for PERSON, ADDRESS and CONTACT. The primary key for PERSON (personID) will be auto-incremented and used as the foreign key for ADDRESS, CONTACT, OWNER, CUSTOMER, and STAFF. When it comes to adding a new record, is there a way to INSERT into PERSON, ADDRESS, CONTACT, and OWNER/CUSTOMER/STAFF at the same time using a simple statement? Or is there another way to retrieve the generated personID and use it to insert into the other tables? I'm testing on Oracle SQL Live 19c.

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=dumpfile.dmp to _expdp_ command arguments does not help. - The user used in login is a DBA. - Tablespace is Users and temporary is Temp with Unlimited space and disk space has plenty of free space. - There is actual data in tables and there are hundreds of tables in the schema. All export jobs succeed without any errors, except that all dumps are 308kb but one 19c it actually dumps schema as dump file is ~100mb. Data Pump Wizard also creates dump 308 kb file. In case, DEFERRED_SEGMENT_CREATION parameter is True. The export log is:

Export: Release 19.0.0.0.0 - Production on Thu Feb 22 11:22:09 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting "MYSCHEMA"."SYS_EXPORT_SCHEMA_01":  MYSCHEMA/********@oracle21c SCHEMAS=MYSCHEMA DUMPFILE=ded 
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Master table "MYSCHEMA"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MYSCHEMA.SYS_EXPORT_SCHEMA_01 is:
  ...\DPDUMP\DED.DMP
Job "MYSCHEMA "."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Feb 22 11:22:51 2024 elapsed 0 00:00:39

What may be wrong with the schema as other schema export as expected creating hundreds of MB dump file but in this case dump has no content?

Not sure how it happened, but somehow my SYS user in my local Oracle 19c database got locked. When I try to log in, I get a "ORA-28000: The account is locked." error. I tried querying dba_users (as one of my other users), and it shows that the account status is "LOCKED(TIMED)". Unfortunately, as far as I'm aware, I don't have any other users that have the permissions to be able to unlock the SYS account. I've scoured the internet for answers about this, but all I can find is people saying that the SYS user actually can't be locked, so I'm not sure how mine got into this state. Does anyone have any ideas about how to fix this?