If you describe the dba_objects, you will find two IDs called: object_id & data_object_id, so , what is the difference between them? object_id is the primary key. Any object will have object_id irrespective, if it has an associated segment or not. For example, sequence, package, synonym are all objects with object_id but without any physical … Continue reading What is the difference between object_id and data_object_id?
While starting a newly created Oracle 19c Listener, I received the following errors; C:\Users\win>lsnrctl start LSNR19C LSNRCTL for 64-bit Windows: Version 22.214.171.124.0 - Production on 06-SEP-2019 13:58:09 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting tnslsnr: please wait… Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error The listener configuration file … Continue reading Oracle Listener 19c Starting Error
While creating an Oracle 19c database I received this error: Install Error [DBT-50000] Unable to check for available memory After some research, I found the following workaround, to start the dbca with specific option: dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false This fixed the error. ThanksAhmed