Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-11g]

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

0
votes
0answers
10 views

Oracle 11g free server frequently raising ORA-12519 during a healthy connection

I have a system where both a web application and a Windows service access a database inside a Oracle 11g server. The server is often dedicated (i.e. only this database exists and only these two ...
0
votes
0answers
24 views

Configuring Oracle forms and reports 11 on centos

I am trying to configure oracle forms and reports 11 on a centos machine. I have tried both centos 6 and 7. In both cases I can successfully install weblogic and forms and reports. I run into ...
0
votes
0answers
46 views

High system CPU utilization

I have a server hosting an Oracle database. It's a 12x2 core CPU with 64GB of RAM running on RHEL5. Lately I've been noticing some sluggishness on the server, upon checking through TOP I found that ...
0
votes
0answers
12 views

Are Oracle auto_login wallets transportable?

We have a 11g Oracle database that contains encrypted data (TDE tablespaces). Oracle wallet is used, whereby ENCYRPTION_WALLET_LOCATION in the sqlnet.ora points to the directory containing the wallet ...
0
votes
0answers
25 views

Refreshing OAM Custom Pages

I'm absolutely new to Oracle Access Manager. I'm learning how to create custom pages on the OAM stack. I am running the Oracle 12c stack/Middleware - all of it. The system is running fine. ...
0
votes
0answers
87 views

OCI8 oracle issue with php7.0 centos 7

I have virtualmin installed with php7.0 , i am trying to install oci8 followed all steps setup enviornment variables but getting this error in httpd error_log /opt/rh/rh-php70/root/usr/lib64/php/...
0
votes
0answers
29 views

Auditing CIS hardening

I am an auditor for IT and Cybersecurity. I am often at client site where I have to review settings on servers and computers, all different operating systems, Oracle databases, even legacy like ...
0
votes
0answers
269 views

Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

am getting the error when trying to connect to remote database i have checked the listener and the services and they are working fine This my Tnsnames.ora file XE = (DESCRIPTION = (ADDRESS = (...
0
votes
0answers
108 views

ssl certificate for Oracle 11g Enterprise manager

i have oracle 11g installed on windows server 2008r2, and i want to issue ssl signed certificate to EM web console "port :1158" but i cant find a working method to do that thanks, Zaid
0
votes
1answer
332 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
44 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 ...
0
votes
0answers
84 views

weblogic filter list of the apps according to their statuses command line

I can deploy and view the status of the apps with weblogic UI from browser. I can even deploy the apps with weblogic.Deployer command line. But I want to list the the apps according to their statuses (...
1
vote
0answers
71 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
0answers
51 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 ...
3
votes
1answer
91 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
178 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 ...
4
votes
4answers
2k 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
131 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
501 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
1k 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
530 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
248 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
380 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
1k 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....
1
vote
0answers
98 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
3k 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
519 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
5k 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
532 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
4k 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
677 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
245 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
534 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
463 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. ...
11
votes
2answers
59k 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
659 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
136 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
257 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 ...
1
vote
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
529 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
3k 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
175 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
44 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
4k 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
63 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
678 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 ...