Questions tagged [oracle-11g]

Oracle is an RDBMS product and Oracle 11g is a specific version.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

What would be considered a **high** redo rate for an Oracle Database in logical standby configuration as compared to physical standby configurations

Considering that our 11.2.0.3 Oracle Database Active Data Guard Configuration (in Maximum Availability mode) is able to keep up with a certain amount of redo without any lag. ( 5MB/s for instance ). I ...
0
votes
0answers
13 views

How to connect Php web app in Linux (Centos) TO Oracle 11g (Database) in Windows Server?

Situation: I am New in linux and deploying projects on servers. I have a server on which i have installed ESXI 6.7. Now i have two Virtual Machines on it. One machine is linux(Centos-8) and the Second ...
1
vote
0answers
87 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 ...
0
votes
0answers
49 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 ...
0
votes
0answers
19 views

Newer ssl on Oracle Linux (RHEL/Centos) 5?

For various reasons (none of which I am comfortable with) I am building a new host for an Oracle database using Oracle Linux 5. Problem 1: the latest full distribution of Oracle Linux is 5.11r1, but ...
0
votes
0answers
60 views

Oracle 11g configuration

I am very new to Oracle 11g installation and configuration, and I am doing this as a part of a POC for a project (that's why not using a latest version). I have installed Oracle database and not sure ...
0
votes
1answer
54 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.stack.imgur.com/59Eg4.png However, my ...
0
votes
2answers
680 views

High INACTIVE memory

i usring Oracle Enterprise Linux 6.5 and Oracle Database 11g when i execute "top" show this to me top - 14:08:02 up 5 days, 18:34, 2 users, load average: 0.00, 0.01, 0.05 Tasks: 340 total, 1 ...
2
votes
0answers
54 views

oraInventory issues on solaris

I have created a script to install oracle 11g on Solaris. My script works 100% well on solaris 10/13, but fails on 10 9/10. The install logs are exactly the same up until this point: INFO: Waiting ...
0
votes
1answer
780 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 ...
0
votes
0answers
48 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 ...
1
vote
0answers
104 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 ...
3
votes
1answer
198 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 ...
2
votes
1answer
137 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 ...
0
votes
2answers
373 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 ...
5
votes
4answers
3k views

Can I run an Oracle server without swap?

Official Oracle docs say that for a machine with more than 16GiB of RAM we need to allocate 16GiB of swap. Our servers are RHEL 7 and have 256GiB of RAM. DBAs do not want to see the system swap, so ...
1
vote
1answer
217 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 ...
1
vote
2answers
2k views

Problems installing Oracle Database 11 on solaris 11.3

i'm trying to install Oracle Database on Solaris 11.3 and i'm getting the following error: INFO: /usr/ccs/bin/make -f /u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk relink ...
-1
votes
1answer
689 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 ...
0
votes
1answer
2k views

Installing Oracle 11g on CentOS via Yum

I'm trying to set up a CentOS 7 VM to host an Oracle 11gR2 database. There is no desktop/x window system software, but I did try installing the 11gR2 zips with ./runInstaller -silent -noconfig -...
-1
votes
1answer
652 views

Migration between Oracle and Azure SQL Data warehouse using SSMA

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...
0
votes
1answer
298 views

sql server migration assistant for oracle to azure sql

I am facing below error while syncing table from oracle to Azure SQL database using SSMA tool(A tool used to migrate data from oracle to azure SQL). Please suggest a solution. Errors: USE ...
-1
votes
2answers
1k views

Save ODBC credentials for Oracle on Windows

On my dev machine (Mint Linux), I have ODBC set up with credentials so that I only have to specify DRIVER and DBQ in the connection string. Unfortunately, the script will have to run on a Windows ...
0
votes
0answers
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....
2
votes
1answer
183 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,...
0
votes
1answer
4k views

Cannot start Weblogic managed node : Stuck at <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>

Appreciate you expert help on this issue. Two weblogic managed nodes running in the same machine went down one day , on trying to start them up again using the startManagedWebLogic.sh, observed ...
2
votes
0answers
664 views

ORA-12154 :TNS:could not resolve the connect identifier specified

I have recently migrated one of our web site from Windows Server 2003 IIS 6.0 to Windows Server 2012 R2 IIS 8.5. The site utilises an Oracle DB via an Oracle 11g ODBC driver. An ODBC connection using ...
0
votes
1answer
6k views

Install Oracle 11.2.0.4 to Win2012srvR2

I'm starting to prepare my server to install a new version of Oracle 11.2.0.4 Database. I'm reading some forum... there is problem about thin installation ? Is supported Oracle 11.2.0.4 version into ...
0
votes
1answer
103 views

DataSet.Fill slower after upgrading to oracle 11g

We have migrated from an oracle 10g to an oracle 11g Database. The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 ...
3
votes
1answer
632 views

zpool disappears whenever solaris cluster reboot or power cycle

I have following setup Oracle Solaris 10 -> 5.10 Generic_147147-26 sun4v sparc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit production Oracle Solaris Cluster 3.3u2 for Solaris ...
1
vote
1answer
6k views

ORA-12505, TNS:listener does not currently know of SID after changing port number

I am trying to change oracle tnslsnr port number from default to some other port. After I change port number for tnslsnr from 1521 to 2000 I start geting ORA-12505, TNS:listener does not currently ...
1
vote
1answer
845 views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
0
votes
1answer
3k views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
4
votes
0answers
282 views

mod_ssl client certificates on a reverse proxy

I am trying to add client certificate authentication on a reverse proxy that proxies an oracle application. Before adding, and if i remove the subsequent code, the oracle application is able to start ...
2
votes
1answer
575 views

remote login failed on windows XP, but remote telnet successful on mac

I recently set up an Oracle DB, started the listener on port 1561, and enabled TCP access. I then opened that port to all incoming connections. When I get on my Mac - I can use telnet remoteserver ...
1
vote
0answers
587 views

WebLogic datasource timeout

We have WebLogic 10 with some services running on it. One of our datasources started throwing timeout exceptions. We set Configuration -> Connection Pool -> Test table Name to problem sql. ...
12
votes
2answers
74k views

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
0
votes
2answers
850 views

High iowait despite small amount of write/read

I'm not sure how to interpret this or the next steps, but why is IOWait so high when I have not written/read much from any devices? Background: I am a developer trying to find why the DB seems to be ...
0
votes
1answer
137 views

Is there a way to find out the necessary users, roles, and privileges an Oracle Dump file needs?

I've been tasked with importing this old Oracle dump file from beyond my time - as such, the person that did the exporting, and the server on which it originally resides on is long gone. My knowledge ...
0
votes
2answers
270 views

How do I restore Oracle's default user tables?

The Problem: I've been trying to restore this dump file, but unfortunately, whoever did the exporting did not make it clear on what users, privileges, and roles are required for the database. So I ...
2
votes
1answer
5k views

Unable to connect to an Oracle XE database from another PC, or a local program / webpage

I've installed an Oracle 11g XE on a Linux Fedora machine, successfully created a user, and imported a database into it. My ultimate goal here is to connect an existing PHP website (also residing on ...
0
votes
2answers
647 views

cannot connect to oracle after server crash

Our test server (based on windows 2008) crashed because of a power loss during the weekend. After the restart, all services started successfully but Oracle 11.2 didn't. I tried to start all services ...
0
votes
1answer
4k views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details Net Configuration ...
1
vote
1answer
207 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
1
vote
1answer
46 views

Retain SIDs and TNS when upgrading Oracle

I am researching the process to upgrade Oracle from 11.2.0.1 to 11.2.0.3. I am planning on using the DBUA utility. My question is, will the DBUA make the necessary changes to retain my SIDs and update ...
2
votes
1answer
5k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
1
vote
1answer
65 views

Dataguard needed for onsite virtualization?

In moving both an Oracle DB and it's corresponding dataguard box both to a Virtual Environment, (Same site, same VM Infrastructure) Does it make sense to keep the dataguard setup? The VM ...
1
vote
2answers
736 views

What kind of performance overhead with LVM on Fusion ioDrive2 as Oracle DB 11gR2's Flash Cache?

This is a bit wordy, so please bear with me. :) We have a RAC cluster of 3 Oracle 11gR2 servers and purchased FusionIO ioDrive2 PCIx cards for these servers to use as OracleDB's Flash Cache. These ...
0
votes
1answer
2k views

Resizing partitions/moving /u01 oracle directory

I've got a test server recently set up at work which has oracle installed under /u01 - but without realising it, I've set the root partition to be ~50GB, so have filled the partition very quickly once ...
3
votes
3answers
5k views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...