Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.

learn more… | top users | synonyms

1
vote
2answers
2k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
3
votes
5answers
40k views

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i ...
-1
votes
1answer
16 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
0answers
6 views

Trouble activating Single Sign-On (SSO) on Trial subscription to Oracle Cloud

everybody First, I am not sure I am really on topic here, but Oracle's own "cloud" support and community forums are not helpful (they get very little traffic and there were no responses yet). Maybe ...
0
votes
0answers
34 views

“Roll back process” for servers during different penetration testing in case of something goes wrong?

In some extent, different kind of vulnerability assessment and penetration testing may impact on target system. I am looking for the solution/rollback process for server if something goes wrong during ...
0
votes
0answers
15 views

Cannot create an instance of OLE DB provider. Error 7302

I am trying to connect to Oracle server from SQL server. I have installed Oracle DB and trying to create linked server following this link. But when I click ok on creating linked server it fails ...
0
votes
0answers
62 views

c3p0 commit is always called even if queries are not executed(data is coming from Ehcache)

I have a web service which makes readonly call(bunch of select queries) to get data from DB. But it makes call to the database for the first time only, after that, all entities involved are cached in ...
0
votes
1answer
2k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
0
votes
1answer
49 views

Weblogic server hangs when “Creating data source connection pool named”

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
2
votes
1answer
2k views

How do I ensure that the SQL*Net keepalive is turned on?

I have a public facing application server that accesses an Oracle database that resides behind a firewall. Some of the processes that are executed through the application server can run for over an ...
4
votes
1answer
5k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
7
votes
4answers
107k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
1
vote
2answers
1k views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
0
votes
0answers
13 views

Open APEX app outside my network

I have Oracle APEX installed on dB 12c on a linux box on my home network as a sandbox. When on this box I can open firefox and goto the below link and login fine. ...
0
votes
0answers
13 views

What's the clean way to rollback a hung OBIEE 11.1.1.7 installation

Looks like using the deinstall option would wipe out the entire HOME & BI cluster. While we are trying to restore down to the 11.1.1.6 previous installation. Windows platform. We were using the ...
0
votes
1answer
29 views

pear/MDB2_Driver_oci8 requires PHP extension “oci8”

I got this Error: unable to find package 'MDB2_Driver_oci8' file 'MDB2/Driver/oci8.php' so I tried to install it with pear install MDB2_Driver_oci8-1.4.1 but following Error is showing up ...
0
votes
1answer
27 views

Port forwarding via Watchguard

I have problem with accessing oracle database with oracle SQL developer. I'm using Watchguard m400 as my firewall/router and Windows Server 2012 R2 as Oracle DB Server. I have server with local IP, ...
-5
votes
2answers
58 views

Unknown Linux Server Reset [closed]

We have a infamous box out of 4 running on the kernel version below. Linux **** 2.6.32-431.5.1.el6.x86_64 #1 SMP Tue Feb 11 11:09:04 PST 2014 x86_64 x86_64 x86_64 GNU/Linux The box now is suffering ...
1
vote
0answers
10 views

Limiting Oracle instances resources with Cgroups?

Is it possible to limit the amount of resources (I/O, CPU and Memory) a Oracle instance can consume using only cgroups? (no containers or virtualization) The reason I wanna do that is because I want ...
1
vote
1answer
694 views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...
1
vote
1answer
62 views

Oracle invoked oom-killer even when RAM and SWAP is plenty free?

Can you please tell me what cause this Oracle process killed? Seems like plenty of RAM free, and plenty of SWAP free. There followed few other oracle processes killed. The VM has the 16G of vMem and 8 ...
0
votes
0answers
34 views

INS40907 Local node not included in the list of host names for grid installation

My error message indicates that I am not including the local node (even though I am working from the private network local node I assume it is looking for the public network node) [INS - 40907] Local ...
0
votes
1answer
29 views

Establishing new IP address when launching multiple instances of the same Oracle VirtualBox image

I've created a new Oracle Virtual Box image and exported it to an "Open Virtualization Format Archive" (ova file). The original image used "NAT" settings. I've since changed it to "Bridged Adapter" ...
0
votes
0answers
38 views

How to export particular table schema and data using ora2pg migration?

I'm using ora2pg migration tool for migrate table schema and data from ORACLE database to Postgres Database. Using the following query, I can export the entire schema and data from the ORACLE ...
1
vote
2answers
45 views

Add redhat yum repo to oracle linux

I'm running oracle linux 7.2. The Oracle yum repo is comparatively small, containing only core enterprise packages. How can I add the redhat yum repo so I can install other userspace utilities?
2
votes
3answers
380 views

Install Oracle Java JRE 7 on Ubuntu with just the command line

I can't use openjdk because it doesn't have native .jpg support. I can't use sudo apt-get install sun-java6-jre sun-java6-plugin any more because apparently those have been pulled. JRE version 7 ...
1
vote
0answers
128 views

tnsping and lsnrctl hung when about to exit – Oracle 12.1.0.2.0 on virtual Windows 7 VM on Mac [closed]

I am trying to run an Oracle installation on Windows 7 running in a virtual machine (Parallels or VMware) on a MacBook Pro (Retina, 15-inch, Mid 2015). When executing Oracle utilities like tnsping ...
0
votes
1answer
60 views

Server becomes unresponsive [closed]

Our database-server sometimes become unresponsive. It runs a fully updated Ubuntu 14.04 LTS. Notable non-vanilla software running on it are Nimbus, TSM and Oracle. About once a day, it becomes ...
0
votes
0answers
55 views

Custom oracle linux 6.7 image on google cloud hangs at 'Booting from 0000:7c00'

I am trying to create a custom oracle linux 6 image on Google compute engine. I followed all the steps as described in the google instructional videos here ...
2
votes
1answer
3k 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 ...
13
votes
6answers
23k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
1
vote
1answer
239 views

How to detect php -oracle using ubuntu nginx php7-fpm

I am running a Ubuntu-nginx-php7-fpm machine and phpinfo() does not detect the oracle extension. How can i tell to nginx or php that the oracle-php extension is installed? The machine is a clone ...
0
votes
0answers
118 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: ...
6
votes
4answers
14k views

How to install Oracle's exp / imp binaries

I was browsing the net to find a solution, but I had no luck. :( How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
1
vote
1answer
3k 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 ...
2
votes
3answers
10k views

Oracle XE 10g: missing file spfileXE.ora (Windows Server 2008 64 bit)

I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine. After the installation the connection to the database administration page http://127.0.0.1:8080/apex fails. If ...
0
votes
3answers
672 views

SQL Server 2005 - Oracle Linked servers stop working

[URGENT - PRODUCTION ISSUE] All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...
1
vote
1answer
1k views

What permissions do I need to run SQL*Loader?

What permissions does a database user need to be able to run oracle's sql loader? For instance, since sql loader will disable indexes and triggers, does it need ALTER permissions for those items? ...
1
vote
3answers
3k views

How is Oracle Solaris 11.x licensed?

can this be used in a corporate LAB? as a storage server for DEV&TEST, not production. free to use for: Developing Testing Prototyping Demonstrating your applications how are the repository, ...
1
vote
0answers
13 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; ...
1
vote
1answer
323 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
0
votes
0answers
22 views

export vmware disk share ovf for RAC

I have one oracle RAC, which is configured as share disk(rac-node-2 share the vmdk of rac-node-1). Right now, I want to export the ovf template of oracle RAC, I hope when I import the ovf template ...
2
votes
0answers
389 views

How do I configure in IBM WebSphere 8.5.5 a data source using Oracle Wallet?

I have a server with a fresh installation of WebSphere Application Server 8.5.5 and I'm trying to configure a data source over a connection using JDBC and Oracle Wallet for SSL. The error message in ...
1
vote
3answers
971 views

no suitable image found when installing Oracle on Mac OSX

I'm installing Oracle Database 10g Release 2 (10.2.0.4) for MAC OS X on Intel x86-64 I have Mac OS X 10.6.7, running at Intel Mac. When I start installing, I am faced to the following error: ...
0
votes
1answer
15 views

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I ...
5
votes
2answers
3k views

Rename a machine after oracle (XE) installation

I am looking for a quick solution for the following problem: I have one virtual machines (vmware) I want to be able to give to colleagues (copy of the vm). I installed on the machine Oracle XE ...
6
votes
2answers
20k views

How do I find out which tnsnames.ora file is being used by my linux system?

When I do an updatedb and locate tnsnames.ora I get back a long list due to various Oracle DB installations. I need to add some entries to whichever is the "default" tnsnames.ora configured for the ...
0
votes
0answers
12 views

Oracle 9i - Data Guard - how to completely resync existing stanby?

Thank's to another SF user, I've managed to recover the control file needed to start a target data guard database in standby mode. So I have an active primary running in ALM keeping only the last 14 ...