Category 219
Discussion List
-
clone DBCS VMHi Experts, Our DB version 19C. We have two OCI database systems PRODDB and TESTDB, each contains only one pluggable database. Is there any option to clone pdbproddb int… -
Oracle Base Database Service - DBCS VMHi Team, We have provisioned a DB system- VM in OCI. We have got CDB with single PDB. We have created one more PDB from the console. Is it possible to have unique names …
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
23ai database version not shown in always free autonomous databaseSummary: I am trying to spin up an always free autonomous DB with 23ai database but only 19c is available as of 8th May 2024. current region is India South Hyderabad Con…
-
Compute instance configurationHi Experts, Need your expertise. We have created a compute instance with oracle linux 8 image. Is it recommended to enable In-transit encryption? Do we have to enable se…
-
How to Get Invoice data by Rest API with from and to date FilterSummary: Description/fscmRestApi/resources/11.13.18.05/invoices ( Using this API and ge... Content (please ensure you mask any confidential information): Version (includ…Kailash Joshi 11 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Formatting & Partioning disk - DBCSHi Experts, Our team created compute instance with block voume size 200GB. Now Attaching blcok volume to instance. Please let us know if below approach looks good or any…
-
OCI-Oracle Base Database ServiceHello Experts, We are using Oracle Base Database Service. We have created a database system. We are trying to connect to database host, to connect as sysdba and run some…
-
Oracle Base Database Service - DBCS VMHi Team, We are installing Oracle Database Cloud Backup Module in OCI VM DB system,but failed. DB version 19.22 →We have created a bucket in object storage →[oracle@apex…
-
Compute instance creation - Block Volume BackupHi Team, We are creating a compute instance in DBCS. While we create the instance,we have an option select backup policy with gold,silver and bronze. Taken below stateme…
-
Invalid Oracle Home ORACLE_HOME : /opt/oracle/product/23c/dbhomeFreeSummary: I tried to run typical healthcheck tools `orachk` in oracle 23c developer free edition The command itself is available out-of-box, but I see execution result as… -
Database - NetworkHi experts, We have dev,uat and prod. We are in POC. Do we need to create seperate vcn for prod and test environments. OR Can we use same vcn for all environments. Pls s…
-
-
-
-
No Performance Data in Enterprise Manager for DBCSSummary: No Performance Data in Enterprise Manager for DBCS Content (required): I need to analyze sql statement for OCI DBCS 19C's performance tuning. However there is n…
-
installation of oracle goldengate microservices on 19c databaseHi Team I am configuring replication using oracle goldengate microservices on 19c database. Could you please advise which version of oracle goldengate microservices I sh…
-
How to acces the DBMS_NETWORK_ACL_ADMIN package to append host ace in ATP as ADMIN userSummary: In SQL Developer I'm connected to a Oracle Autonomous database 19c as ADMIN user. I want to debug a procedure with the integrated tools. After following a quick…
-
There is no spanish(EN) transulation in Table(FND_APPLICATION_TL)Hi Team, There is a column called error_warning_message from" FUSION_ORA_ESS.REQUEST_HISTORY" customer wants to convert the error warning message column to Spanish langu… -
How to identify invalid date values in a varchar columnSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex)Summary: How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex) Content (required): I would like to change the shape of an existi… -
Where binding variable of a Fusion page is saved ?Summary: Page path: My team --> show more --> Team time card --> enter to anyone time card This is the Time Card page there is a lot of binding variables i want know whi…
-
can one grant references to role?In our environment all developers accounts have the role 'Developer', this role has all the necessary permissions to do what they need to do bar one which seems crazy. I…Ali Mehmet - Turning Point 15 views 3 comments 0 points Most recent by Ali Mehmet - Turning Point Database -
Please share sample code that takes Json array as in value and out value in to package procedureSummary: Looking for a sample code that takes Json array as IN parameter into the package using json_array_t Looking for a sample code that takes Json array as OUT param…
-
How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloperSummary: How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloper I Try To Log With Next Methods and It Refuses To Login Database Password Cre… -
rman active duplicate miscalculates sessions & processes parameters to start the auxiliary instanceSummary: When I start "dbaascli database duplicate" to create a duplicate database from a Snapshot Standby database rman active duplicate is miscalculating sessions and … -
How to create backup for Oracle SaaS InstancesSummary: I want to know: What is the minimum and maximum duration for which Oracle SaaS instance backup can be taken? If we can take backup of server outside oracle. Ste…
-
Oracle Certifications for Beginner VBCS Developers using pl/sql , apexBeginner level oracle certifications for VBCS Developers using pl/sql , apex for career growth. -
Rman Backup is too slowSummary: Full database rman backup is too slow in windows machine. How to find out the bottleneck ? Content (required): run{ ALLOCATE CHANNEL d1 DEVICE TYPE DISK; ALLOCA… -
Datapump Export of DDL is extremely slow on On-PREMSummary: Datapump Export of DDL is extremely slow on On-PREM Content (required): Source Database size : 4.5 TB Platform: AIX DB Version : 12.2.0.4 For Migration purpose,…