ORDS Version : 18.2 Oracle Version : 12cR2 Error : The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named HR Desc: The error occurs when you have published a RESTful web service from a table inside a schema. When you try to call the Webs service … Continue reading ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named
While creating a on-premise 18c (18.3) database with DBCA in the silent mode I got the below error dbca -createDatabase -silent -gdbName ora18c -templateName General_Purpose.dbc -sysPassword sys123 -systemPassword sys123 -dbsnmpPassword sys123 -datafileDestination /u01/oradata -storageType FS -memoryPercentage 20 -emConfiguration NONE -sampleSchema false [FATAL] [DBT-50000] Unable to check for available memory. [FATAL] [DBT-50001] Unable to check the … Continue reading Oracle 18c (18.3) DBCA Issue – [DBT-50000] [DBT-50001]
This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded MySQL Server (51. to 5.6 in my case) . After upgrading your MySQL you have to run mysql_upgrade to fix any incompatibilities in System tables. If it finds any errors it automatically repairs it and … Continue reading Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50560. Please use mysql_upgrade to fix this error.
This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’
Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 18.104.22.168 DB Home Version : 22.214.171.124 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)
Oracle Version Affected : 126.96.36.199 OS : OEL 6 Update 7, x64 This error is related to Parallel Query and we encountered it many times, once on test and once on production. The solution is to apply below patch Patch 19201867: SR12.2PX_HYBRID_LOAD - TRC - ORA-600 [KXSPOAC : EXL 1] It is due to a … Continue reading ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], , , , …
While installing Oracle 12c on Linux you can get this error. The solution is very easy just unset the ORA_CRS_HOME environment variable and run the runInstaller again $ unset ORA_CRS_HOME