Questions tagged [oracle-11g]
Oracle is an RDBMS product and Oracle 11g is a specific version.
169
questions
0
votes
0
answers
173
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 &...
1
vote
1
answer
2k
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 ...
1
vote
0
answers
355
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
0
answers
108
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
0
answers
189
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
1
answer
67
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
2
answers
4k
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
0
answers
80
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
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 ...
0
votes
0
answers
95
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
0
answers
174
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
1
answer
480
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
1
answer
382
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
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 ...
5
votes
4
answers
5k
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
1
answer
378
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
2
answers
3k
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
1
answer
852
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
1
answer
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
1
answer
771
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
1
answer
407
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
2
answers
2k
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
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....
2
votes
1
answer
448
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,...
1
vote
1
answer
6k
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
0
answers
784
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
1
answer
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
1
answer
113
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
1
answer
816
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
1
answer
8k
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
1
answer
1k
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
1
answer
4k
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
0
answers
336
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
1
answer
639
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
0
answers
718
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.
...
13
votes
5
answers
92k
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
2
answers
1k
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
1
answer
232
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
2
answers
373
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
1
answer
7k
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
2
answers
898
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
1
answer
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
1
answer
242
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
1
answer
54
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
1
answer
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
1
answer
72
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
2
answers
846
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
1
answer
3k
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
3
answers
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 ...
0
votes
1
answer
307
views
Windows 2003 Near Freezing
Problem: Our server becomes very very slow (near freezing) if I copy a file from any directory on C: and D: to any other directory. In short It becomes very slow if I touch the hard disk. Currently I ...