All Questions
12 questions
-1
votes
1
answer
56
views
Replication between two Cloud Services
Is it possible to implement SQL Server Replication between two disparate cloud services?
For instance, if I have an instance running in Amazon's AWS Cloud Service and another instance running in ...
0
votes
0
answers
475
views
Will SQLNET.EXPIRE_TIME=5 prevent AWS Gateway Load Balancer from timing out after 350 seconds?
We have Amazon Web Services (AWS) Database Migration Service (DMS) tasks erroring out against an on premises Oracle 11.2.0.3 database with ORA-03135 errors. Our network traffic between AWS and the ...
- 221
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
933
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 ...
1
vote
1
answer
5k
views
Access or modify tnsnames.ora on AWS Oracle RDS
I have an Oracle RDS instance running on AWS and I need to access the tnsnames.ora file and check its configuration since I am getting this error
Caused by: oracle.net.ns.NetException: Listener ...
- 231
0
votes
1
answer
2k
views
Script to install Oracle client 12c2 on Redhat linux 7.5
Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
- 1
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
1
answer
430
views
AWS ORACLE Linux 7.4 - Connection issue
I tried to install oracle 12c in Oracle Linux 7.4 instance upon AWS ORACLE Linux 64 EC2 instance,
I could make the installation and connect to the database from the ec2 server without any issue ...
- 13
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
1
answer
10k
views
What's the default password for SYSTEM in Amazon Oracle RDS?
I can only remember setting these parameters and definitely not the password for SYSTEM:
DB Instance Identifier = mydbinstanceidentifier
Master Username = mymasterusername
Master Password = ...
- 133
1
vote
1
answer
1k
views
sqlplus works specifying the parameters but fails when using tnsnames.ora
I've been turning google upside down and couldn't find an answer. I can connect to my oracle instance like this:
sqlplus 'myuser@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=msoracle.cnujcn8mkxea.us-...
- 161
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