All Questions
Tagged with oracle oracle-11g
89
questions
0
votes
0
answers
185
views
Getting high read await in Zabbix monitoring, is this a common behavior for RAID5 disk array?
We are running a Oracle 11.2 DB on Redhat 6.8, and disk array is configured as RAID5, which is using a Lenovo 730i RAID adapter.
I checked RAID policy and found that "Read Ahead Always" and &...
- 21
1
vote
1
answer
3k
views
ICMP ping fine but tnsping timeout to oracle
We have Oracle running on a Windows server and a couple of Linux clients. Windows clients work just fine. However, running tnsping on a Linux (running RHEL 6.9) client has an interesting issue. Take ...
- 745
1
vote
0
answers
368
views
Oracle reports SMTP change
We recently migrated our SMTP address from smtp.old.example to smtp.new.example, this caused our Oracle reports server to stop sending emails which was expected.
I have updated the <pluginParam ...
- 113
0
votes
0
answers
114
views
Sum of bytes of database files of oracle database is showing more than the physical used size of the mount point
We are having oracle 11g2 database on Solaris 10. We have all data files under single mount point say /u001 and we make the sum of bytes of all data files which is more than the physical used size of ...
- 1
0
votes
1
answer
70
views
Incorrect Oracle host
I have an issue with oracle 11g installed on a Windows Server 2016.
When I create a new DB the hostname is always as the following image shows.
https://i.sstatic.net/59Eg4.png
However, my hostname ...
- 103
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
0
answers
115
views
How can I recover oracle database without new data?
I have oracledb 11g. I setup archivelog mode on my server. There's my backup\recovery scenario:
rman TARGET SYS/pass@XE
RMAN> backup database plus archivelog;
After that I make changes to the ...
- 101
1
vote
0
answers
184
views
Resolving FIPS Compliance Issues with Oracle 11g
Problem
I am working with Oracle DB 11g (11.2.0.4.0 - 64bit), Jenkins, Windows PowerShell plugin, and VsTestRunner plugin to automate running unit tests. While setting this up I stumbled upon a huge ...
- 111
3
votes
1
answer
530
views
What better way to configure memory for an Oracle RAC 11g R2?
I'm setting up a new environment in Oracle RAC 11g but I'm wondering how best to use the memory feature.
Today I have two servers with 128GB of RAM 1 core CPU with 16 cores.
I deployed 64GB of SSD ...
- 31
2
votes
1
answer
410
views
RHEL 5.8 [Oracle] too long to shutdown
We are using Oracle database on a machine running RHEL 5.8.
Every month we restart our servers (including this one) however this one takes too long to shutdown. Last time took it 40 minutes.
This was ...
- 21
0
votes
2
answers
1k
views
LD_LIBRARY_PATH Configuration Setup Issues
I am facing a weird but a sensible issue, I have 2 ORACLE_HOMEs, 1st one points to ORACLE Database Software and 2nd one points to ORACLE Client Software.
Why I am forced to do this - reason is: In my ...
- 143
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
-1
votes
1
answer
859
views
Unable to connect to an Oracle XE database from Oracle Sql Devloper
I've installed an Oracle 11g XE on a Linux ubuntu 14.04, successfully created a user, and imported a database into it.
my problem is , if when I want create new connection for connect with DATABASE hr ...
- 1
0
votes
0
answers
2k
views
Error while running sqlplus after installing Oracle Client 11g R2 on RHEL 7
I am facing issue while running ./sqlplus command after installing Oracle Client 11g R2 on RHEL 7
here's is the error:
$ ./sqlplus
./sqlplus: symbol lookup error: /home/oracle/app/oracle/product/11....
- 45
2
votes
1
answer
478
views
How to delete alogs fom Oracle downstream target
I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns,...
- 299