All Questions
Tagged with amazon-rds oracle
28 questions
1
vote
1
answer
87
views
ORACLE: RDS On AWS
This may be a lack of understanding as I am a MSSQL DBA more than Oracle.
We are running Oracle on RDS in Amazon.
Engine Version 19.0.0.0.ru-2020-10.rur-2020-10.r1
I dropped an old _backup table but ...
- 431
0
votes
2
answers
103
views
Oracle Batch Deletion
I have an Oracle table that has over 1.8 Billion rows, I need to delete up to 260 million of these rows.
I am a Microsoft SQL DBA, so not fully comfortable with the Oracle syntax and best practices ...
- 431
0
votes
1
answer
206
views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
I am getting ORA-00942: table or view does not exist when tried to query the same.
- 13
0
votes
1
answer
222
views
How can I monitor and address fragmentation on RDS for Oracle database?
I'm planning to migrate my database from on-premises to AWS RDS for Oracle. However, I'm not sure if Amazon RDS supports tools such as Automatic Fragment Advisor or the Automatic Segment Space ...
-2
votes
1
answer
106
views
AWS TO OCI GOLDENGATE REPLICATION
I want to use oracle Goldengate to my Multi cloud setup database, I'm just wondering if Im required to down my primary database to avoid data discrepancy? or goldengate can sync the data even if my ...
0
votes
1
answer
65
views
SQL code Compatibility: Migrating an Oracle RDS database to an Athena Trino Datalake
We are thinking of migrating an Oracle RDS database to Athena Trino Datalake.
We would keep all database names, schemas, tables, and columns the same.
Would SQL that runs correctly against the Oracle ...
- 157
0
votes
0
answers
1k
views
Oracle Storage Full, How to release space?
i have and AWS RDS Oracle Database wich its storage is full, looks like the cause is SYSAUX tablespace with 10.2GB size
The largest object inside SYSAUX is: WRI$_ADV_OBJECTS (TABLE) checking the table ...
0
votes
1
answer
935
views
delete obsolete archivelog
I have an oracle instance aws recently migrated to RDS aws
I just noticed that my database is set by default in archivelog mode and that the archivelog are not deleted
who has any idea how deleted the ...
0
votes
1
answer
1k
views
Importing huge table exhausts UNDO extents in Oracle RDS (ORA-01628)
I'm attempting to do an impdp on RDS, Oracle 12c. I'm importing only one table for this particular impdp job but every time I try to import it, UNDO usage gets to about 50% and then the logs just say ...
0
votes
0
answers
21
views
Access Oracle DB from AWS RSD Mysql DB
I have two databases. One is in Oracle and the other one is in AWS RDS MySQL. How can I access my Oracle Database from AWS RDS MySQL Database?
0
votes
1
answer
5k
views
Verify if the client is connecting to the Oracle database using native network encryption
My environment is as below -
Server: Oracle 12C 12.1.0.2.v17 ( AWS RDS Service)
Client: Windows 2012 machine with Oracle 19C 64 bit full client
Tools : SQL Developer and Toad on the client machine
I ...
- 107
0
votes
1
answer
147
views
Oracle AWS package errors when removing user
We are getting the folowing error when attempting to remove a user from our 11g Oracle. a dump from an Amazon DB was (failed) imported, and now we see this.
ERROR at line 1:
ORA-00604: error occurred ...
- 201
0
votes
1
answer
3k
views
Oracle AWS RDS supermaster user cant grant select on some tables
I'm dealing with some sort of issue beyond my Oracle knowledge. A customer wants to execute some queries to detect issues, locks, etc in a Oracle RDS database. I assume this queries needs database ...
- 123
1
vote
0
answers
295
views
Can I do profiles of an Oracle RDS instance on Amazon?
Is there any way to get histories of queries from a 3rd party application to an RDS Oracle instance?
We have a DB with less than a million rows, and we are running some queries through a 3rd party ...
- 111
2
votes
2
answers
4k
views
DBMS_DATAPUMP error: The current API cannot be executed because of inconsistencies between the API and the current definition of the job
I'm trying to do an impdp on a Amazon RDS Oracle instance using DBMS_DATAPUMP.
I'm following the steps described in the Amazon RDS guide (Importing Data into Oracle on Amazon RDS).
I've already ...
- 337
1
vote
1
answer
2k
views
copy an exported dump file to a target DB instance - LOG
I just imported data into an Amazon RDS DB instance using this guide
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html
But in the source DB the number of tables ...
4
votes
2
answers
1k
views
RDS Oracle SE - Performance troubleshooting options
I have an RDS Oracle SE2 instance with Amazon RDS. Our team is looking forward to move couple of applications to RDS. But we’re looking for options that are available in RDS Oracle SE to perform ...
- 445
3
votes
2
answers
961
views
Oracle HIPAA/FIPS-Compliant Encrypted Connections
I'm currently evaluating encrypting data in-transit for an Oracle SE2 12.1 Amazon RDS instance in accordance with HIPAA requirements.
Specifically, I'm considering the use of Oracle Native Network ...
- 141
1
vote
0
answers
3k
views
Oracle Network Encryption from SQL Developer
I'm configuring Oracle Network Encryption on my Amazon RDS Oracle SE2 12.1 instance per these instructions. I've got the RDS instance configured with the appropriate option group, enabling network ...
- 141
1
vote
1
answer
2k
views
Oracle data pump export / import errors
I'm attempting to export from a physical Oracle 11.2.0.3.0 database to a amazon rds Oracle database.
I used the expdp and exported a full database and incurred no errors upon export.
I've moved the ...
- 131
1
vote
0
answers
901
views
Amazon RDS: Replacing file based workflows in Oracle RDS
Oracle RDS has limitations to how it supports different file workflows
External tables are apparently not supported
It is, to my knowledge not possible to mount a disk and use UTL_FILE to read/write ...
- 111
1
vote
3
answers
6k
views
Import big CSV on Oracle
I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
- 81
3
votes
2
answers
1k
views
How to setup Oracle at Amazon RDS
I created a Relational Database Service (RDS) with Oracle database at Amazon Web Services (aws.amazon.com). However, when I attempt to connect to the database (with SQLDeveloper or Navicat), I am ...
- 211
0
votes
1
answer
1k
views
Unable to migrate local database to RDS instance
I recently created an MySQL instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance from the MySQL command line. I will brief you the details.
1) I want to move/migrate my ...
- 1,131
1
vote
0
answers
223
views
Amazon RDS for Oracle Offsite Backup [closed]
Am considering Amazon RDS to host our Oracle database. Ideally, I'd like to have my daily backup and as many of the transaction logs as possible since copied to an external location in case of Amazon ...
- 11
3
votes
1
answer
6k
views
Example of loading into RDS from S3 using SQL*Loader
Does anyone have a working sample of loading data into an Amazon AWS RDS Oracle database using SQL*Loader where the source file is on S3?
In principle it's clearly possible. The Amazon RDS Data ...
- 357
1
vote
1
answer
8k
views
Unable to connect to Amazon RDS instance [closed]
I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer.
The (relevant) information I have from Amazon;
Endpoint - The ...
- 213
2
votes
1
answer
4k
views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
- 121