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]

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.

0
votes
0answers
4 views

Oracle coalesce not exiting conditions [on hold]

I have a query that I need to evaluate the first case in the coalesce. If the record does not meet any of that criteria, it should move to the next case. The default value should be shrtatt_attr_code ...
0
votes
0answers
8 views

Oracle 11g RW Mirror [closed]

I'm working on my end-of-degree project. Wich involves designing and simulating a corporate network. My current scenario involves 2 offices conected vía IPSec tunneling. In each of these offices ...
0
votes
0answers
22 views

Kubernetes + Calico on Oracle Cloud (OCI)

I am trying to deploy a test Kubernetes cluster on Oracle Cloud, using OCI VM instances - however, I'm having issues with pod networking. The networking plugin is Calico - it seems to be installed ...
1
vote
0answers
21 views

Self-extracting executable not extracting other archives

** Problem We are attempting to run a self-extracting executable (SFX) to install an Oracle product, Oracle Enterprise Manager 13.2. The installation starts, works for a short while, and then quits, ...
0
votes
0answers
18 views

How can I determine the resource usage of a certain userspace in Oracle?

We have all our reporting (including jobs and statistics and analysis data recalculation) being done in one userspace. This is a standard Oracle user. We're now considering moving this reporting to ...
0
votes
1answer
19 views

Oracle RAC installation failure: disk share issue

Oracle RAC installation is failing because of shared disk issue. While running "runcluvfy.sh" to verify the disk share between nodes. it is failing on node2. I have collected trace logs of following ...
0
votes
0answers
10 views

Oracle processor licensing [duplicate]

I am planning to clone my Oracle Standard Edition with 1 processor license from my old server to my new server (two processors). Can it be done? Have anyone done this before without purchasing extra ...
0
votes
0answers
27 views

Error ORA-03113: end-of-file on communication channel

I installed a BD 12c, and every day at a certain time the BD stops working and when I want to start it again, it throws me the following error: Error ORA-03113: end-of-file on communication channel To ...
0
votes
0answers
8 views

Issue with Rewriting an URL for Weblogic Server 10.3.6

I have been working on 2 different web servers(dev-banabc and dev-banxyz), on which we have 2 applications running on each Weblogic Server. I have tried other solutions found on serverfault, however, ...
0
votes
0answers
8 views

Oracle Linux 6.6 DL380 gen9 not booting after installation “Fatal Error”

I Installed Oracle Linux 6.6 on "HPE DL380 Gen9". After the installation finishes, and the server restarts, the OS starts to boot then it stops with the a "Fatal Error" message. I searches for a ...
0
votes
0answers
13 views

Oracle 12c database size increase at a high rate

We have a warehouse management database with Oracle since 2016; before then it was SQL. When it was in MSSQL the usual database size was 40-50 GB. Since we moved to Oracle, the size has been ...
0
votes
0answers
36 views

Configuring the Oracle Database(12c)-Microsoft Active Directory Integration

I am planning to integrate LDAP with Oracle database for authentication management. I do not want to use Kerberos for this. It would be helpful if somebody from here advise whether that is possible ...
0
votes
0answers
41 views

AWS Glue Import CSV to Oracle with ETL deleted entries

I am actually trying to import data from a CSV file in a AWS S3 Bucket into a oracle database with AWS GLUE. This works fine in the beginning. But after deleting a row in the file and starting the ETL ...
0
votes
1answer
37 views

Oracle 12c 32-bit client and direct GOT relocation R_386_GOT32 against `lxecerr’

When trying to install Oracle 12c 32-bit Client (12.1 or 12.2) on Oracle Linux 7.3 or 7.5, it throws error during linking static libraries: INFO: Start output from spawned process: INFO: -------------...
0
votes
0answers
11 views

How can I further improve Oracle 12.1 performance on RDS m4.large instance?

I'm having performance issues with my current Oracle setup. Queries are taking half a second and I can't figure out how to speed it up further. I've upgraded my RDS instance from a t2.medium to m4....
0
votes
0answers
19 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
297 views

Persist alter session set “_ORACLE_SCRIPT”=true; in Oracle 12c

I have an oracle 12c (1.0.2) running in Docker. I'm using a script which is executed during container startup: TESTER IDENTIFIED BY TESTER; This fails with this error: ORA-65096: invalid common ...
0
votes
0answers
56 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
118 views

IMPDP INCLUDE=JAVA_CLASS not working with REMAP_SCHEMA

We're exporting database schema X on db server A and importing it into schema Y on db server B with REMAP_SCHEMA and REMAP_TABLESPACE and including java jars with INCLUDE=JAVA_CLASS. impdp system/*** ...
0
votes
1answer
16 views

Kernel upgrade and Oracle prerequisites error

I am upgrading kernel (Red Hat) from 6.7 to 6.9 with Amazon AMI and when I am installing Oracle through puppet I am getting this pre-requisite error. Error: Execution of '/usr/bin/yum -d 0 -e 0 -y ...
1
vote
1answer
835 views

windows 10 installing oracle client 12c or 18c hanging at step1

I am trying to install Oracle Client version 12c or 18c. I have tried both of the installers, and once I click next, it hangs and won't proceed any further. Same thing happens on both of the setup ...
0
votes
0answers
64 views

Apache httpd reverse proxy on solaris only empty page

this is my httpd.conf file I tested reverse proxy without any virtual hosts in this first draft. Where is the problem? SSL is working fine by the way that is not the problem. # # This ...
1
vote
0answers
76 views

ORA-12541: TNS:no listener

Here is the situation: I have a computer(let's call it server PC, whose IP is 192.168.1.100) that has ORACLE installed on it. I can access the data in oracle using Python on this server PC(This means ...
0
votes
0answers
12 views

Oracle Database - Grant/Revoke High Concurrency

We have an Oracle 10g release 2 database running on a production environment. It's experiencing a lot of concurrency, as Sql Developer 17.4 "Waits for past 1 hour" graph shows. When the database is ...
0
votes
1answer
3k views

Howto install Oracle OCI8 instantclient on Ubuntu 18.04

I want to share some information about my OCI8 installation to access Oracle databases. If you got errors like "PHP Startup: Unable to load dynamic library 'oci8.so'" or "checking Oracle Instant ...
0
votes
1answer
2k views

SQL Developer - The Network Adapter could not establish the connection

This is my first time connecting to an Oracle server. I'm using SQL Developer. They only gave me an IP, the default port (1521), a user name and a password. So I filled them in in the "New / Select ...
0
votes
0answers
24 views

Oracle using DBMS_REDEFINITION for CREATE TABLE AS SELECT

We have to frequently delete about 40% - 50% rows from a large table. We know that CTAS ( create table as select ) is much faster because we can simply do the following 1. Create table new_tab as ...
0
votes
0answers
47 views

Oracle database Listener error

Actually my connection in sql developer was fine while working yesterday. Today I cannot connect and when I checked the status of my listener(LISTENER1), it had, somehow, been terminated. When I tried ...
0
votes
0answers
21 views

Oracle Data Guard and FSFO - what is the guaranteed RPO when the primary enters the stalled state?

I would like to know how Oracle Data Guard and FSFO interact when the primary database becomes isolated from the failover target as well as the observer, but not isolated from all client connections. ...
0
votes
2answers
377 views

How set Oracle Weblogic oraInventory location?

I've downloaded Weblogic Quick Installer from Oracles site (http://www.oracle.com/technetwork/middleware/weblogic/downloads/index.html). I've set ORACLE_BASE and ORACLE_HOME to directories with write ...
2
votes
1answer
747 views

IO Error: The Network Adapter could not establish the connection in Jmeter load test

I'm doing a load test to Web Service SOAP with Jmeter, on non-GUI mode I start to get errors since 300 Number of Threads, this was detected with a "Response Assertion" with this rule: "Test failed: ...
1
vote
0answers
183 views

Can I install oracle linux or debian in Sun enterprise m4000 sparc?

I would like to install a linux OS on this server but after trial and error always came back with a error, i know that the installation is fully compatible with SPARC architecture, every time i used ...
0
votes
1answer
27 views

My instance of Oracle 12c is using up alot of space and I am not sure why How to free up space

I am developer, not an Oracle admin. We have an Oracle 12c instance that is used only by developers. It is currently using up most of the disk space on the machine. The C:\app\OracleUser\product]12.1....
0
votes
1answer
694 views

OCI8 installation issue in Centos 7

I installed PHP 5.6 and Apache 2.4, and oci8 module on my fresh Centos 7 system. The oci8 module is working on terminal, but it's not working in Apache and not showing in phpinfo. I tried to disable ...
0
votes
1answer
292 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
43 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
1answer
404 views

ORA-12154 when trying to connect as SYSDBA

here is my environment Oracle 12.2 NON-CDB The oracle user is part of dba and oinstall group as follows $ id oracle uid=1000(oracle) gid=54322(dba) groups=54322(dba),54321(oinstall) The ORAPW file ...
0
votes
0answers
30 views

Installing Oracle 12c ASM on Block Device

I want to install Oracle 12c ASM for single instance database. Can Oracle 12c ASM be installed on block devices OR regular file system ?
0
votes
1answer
319 views

Does Amazon RDS support multiple oracle databases per instance? [closed]

As you can see the AWS FAQ mentions that we can create only one database per instance for Oracle.
1
vote
0answers
61 views

After some minutes oracle database is down, but listener still active

I installed Oracle 12c R2 on my fedora 24 server. Before its updates and the last upgrade to fedora 26 it was running ok, but then neither the listener nor the database can be bringed up. After some ...
0
votes
0answers
11 views

If Oracle is not installed as the DBA's user account, what steps need to be taken post-installation?

My IT department installs Oracle Database on my Windows machine automatically. However, the installation runs as user "SYSTEM". Because the installation automatically adds whatever user it is running ...
0
votes
0answers
67 views

Cannot Stop Instance - Oracle Change Data Capture by Attunity

I have an implementation of CDC to replicate transactions from an Oracle database to an SQL database using the Change Data Capture tool by Attunity. This implementation works well in replicating the ...
1
vote
1answer
284 views

SQLPlus: Execute SQL scripts located on database server machine

Is there a possibility to execute an SQL script that is located on the database server using SQLPlus? For example, if I execute @@?/rdbms/admin/awrrpti.sql the SQL file located on the client machine ...
0
votes
0answers
65 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 (...
0
votes
0answers
305 views

Weblogic 12c ohs silent installation; Domain Reconfiguration

I am trying to automate the process of Weblogic OHS installation through PowerShell. As a prerequisite Fusion Middleware, RCU configuration and domain reconfiguration with em and jrf has to be done. ...
0
votes
1answer
3k views

SQL Developer cannot connect but SQL*plus can

I have a developer who is able to connect to Oracle database using SQL*Plus from command line. But the person is not able to connect by using SQL*Developer. The error is as follows : "IO Error: The ...
-2
votes
1answer
51 views

Why would my Oracle read from disk?

Our Oracle server (version 12c) is running on a RedHat-6.7 server with 128GB of RAM. The current size of the only database on it is only about 60GB. Yet, we see plenty of disk reads -- on the device ...
0
votes
1answer
85 views

Install Tensorflow on Oracle Application Server with AIX

I would like to install python and Tensorflow on the Oracle Application Server operating on IBM AIX. I have not been able to find any documentation for installing python on AIX, much less on Oracle ...
1
vote
0answers
107 views

Unable to use expdp over database link

I'm trying to use Oracle's expdp to export a remote schema using a database link. I think the database link works fine, since I can execute select queries through it. When I try to execute expdp, I ...
1
vote
0answers
61 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 ...