All Questions
89
questions
1
vote
0
answers
121
views
How to enable SQL trace for AWS Oracle RDS
To enable sql trace under Oracle you would typically run the following via sqlplus after login:
ALTER SESSION SET SQL_TRACE=TRUE
On Oracle 19 RDS this results in the following:
Error report -
ORA-...
- 11
0
votes
1
answer
280
views
Connecting to Oracle Autonomous Database with PHP and OCI8
I'm using Oracle Cloud Infrastructure. I have a VM instance with Ubuntu-22.04-Minimal. Apache, PHP, and OCI8 are all installed and working.
When I try to connect to the database I get:
Warning: ...
- 101
1
vote
1
answer
284
views
Oracle database - solaris 10 9/10 where is i can find
We have Oracle tech login but cannot find the elusive Solaris 10 9-10 SW load iso file.
We have just about everything else for Sol 10 .... and can't restore a an ORACLE DATABASE backup without it to ...
-1
votes
1
answer
1k
views
Users and Roles Extraction in Oracle
I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this:
SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
- 7
1
vote
1
answer
308
views
Integration of Azure with Oracle Cloud Infrastructure (OCI) ORA-03113: end-of-file on communication channel
I'm trying to integrate Azure and OCI using this approach and this article.
Now, I have the infrastructure up and running. It consists of a VM in Azure, an Autonomous Database (ATP) Oracle Cloud ...
- 61
0
votes
1
answer
130
views
Oracle Database Realtime Sync
Client is using Oracle Database Standard Edition so Active Data guard feature is not available and he wants to have a standby replica of the database which can take over the environment as soon as the ...
3
votes
2
answers
12k
views
AWS Database Migration Service requires a role not mentioned in documentation
I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the ...
- 31
0
votes
0
answers
20
views
How can I further improve Oracle 12.1 performance on RDS m4.large instance?
I'm having performance issues with my current Oracle setup. Queries are taking half a second and I can't figure out how to speed it up further.
I've upgraded my RDS instance from a t2.medium to m4....
- 1
6
votes
1
answer
31k
views
Howto install Oracle OCI8 instantclient on Ubuntu 18.04
I want to share some information about my OCI8 installation to access Oracle databases.
If you got errors like "PHP Startup: Unable to load dynamic library 'oci8.so'"
or "checking Oracle Instant ...
- 301
0
votes
0
answers
541
views
Oracle database Listener error
Actually my connection in sql developer was fine while working yesterday. Today I cannot connect and when I checked the status of my listener(LISTENER1), it had, somehow, been terminated. When I tried ...
- 1
0
votes
1
answer
2k
views
Oracle 12c schema restore using impdp from a different server
I have created 2 EC2 instances in AWS.
One acts as DB Server and one acts as client.
Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server.
I have ...
- 213
0
votes
1
answer
2k
views
ORA-12154 when trying to connect as SYSDBA
here is my environment
Oracle 12.2
NON-CDB
The oracle user is part of dba and oinstall group as follows
$ id oracle
uid=1000(oracle) gid=54322(dba) groups=54322(dba),54321(oinstall)
The ORAPW file ...
- 161
0
votes
0
answers
997
views
Workaround for email "Received:" header displaying internal IP address?
I have a database server connected to an application server. The database server contains SQL code that generates automated emails to customers. The database server code creates the email then logs ...
- 176
1
vote
1
answer
386
views
Can oracle handle SERVER = POOLED (DRCP) and SERVER = DEDICATED clients simultaneously?
I run a PHP application that uses an Oracle 11g instance as it's backend. We currently connect with DEDICATED as our type but we're having trouble scaling.
As such, I suggested to the DBA we ...
- 163
0
votes
1
answer
691
views
Number of Active Database Connections Performance Counters?
We are using OleDbConnection class to connect Oracle and SqlServer. At some places we are also using SqlClient and Oracle.DataAccess.OracleConnection. I need to know how many active connections our ...
