Questions tagged [oracle-11g]

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

Filter by
Sorted by
Tagged with
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 &...
Jason Yang's user avatar
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 ...
Natalie Adams's user avatar
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 ...
Ben Maxfield's user avatar
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 ...
Ora-dba 's user avatar
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 ...
serverstackqns's user avatar
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 ...
Alex Coronas's user avatar
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 ...
Soheil Mamdouhi's user avatar
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 ...
warhansen's user avatar
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 ...
nirmalraj17's user avatar
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 ...
NCNecros's user avatar
  • 101
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 ...
Brandon's user avatar
  • 111
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 ...
Bruno Farias's user avatar
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 ...
charsta's user avatar
  • 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 ...
Gaurav Bhaskar's user avatar
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 ...
chutz's user avatar
  • 7,990
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 ...
user126715's user avatar
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 ...
josseossa's user avatar
-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 ...
BkarimCe's user avatar
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 -...
Orphid's user avatar
  • 101
-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 ...
shreya's user avatar
  • 9
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 ...
user1795999's user avatar
-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 ...
Thom Smith's user avatar
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....
user212051's user avatar
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,...
shcherbak's user avatar
  • 299
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 ...
Jimmi Skaria's user avatar
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 ...
Brady's user avatar
  • 21
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 ...
Francesco Irrera's user avatar
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 ...
shadowsheep's user avatar
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 ...
Halit Sakca's user avatar
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 ...
user2391's user avatar
  • 113
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 ...
sathish kumar's user avatar
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 ...
Thomas Bratt's user avatar
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 ...
Rory McDonald's user avatar
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 ...
jwillis0720's user avatar
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. ...
dzmitry's user avatar
  • 133
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 ...
Brandon's user avatar
  • 133
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 ...
Will's user avatar
  • 441
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 ...
zack_falcon's user avatar
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 ...
zack_falcon's user avatar
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 ...
zack_falcon's user avatar
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 ...
Doc's user avatar
  • 273
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 ...
bjan's user avatar
  • 101
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 ...
lilott8's user avatar
  • 496
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 ...
sreimer's user avatar
  • 2,248
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 ...
ssgao's user avatar
  • 121
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 ...
dangelsaurus's user avatar
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 ...
Mxx's user avatar
  • 2,382
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 ...
Jon Story's user avatar
  • 139
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 ...
Maciej Hehl's user avatar
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 ...
Kaveh Shahbazian's user avatar