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. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/

Filter by
Sorted by
Tagged with
0
votes
0answers
31 views

Installing Oracle JDK using Ansible

I've been researching this for a while and it seems that installing an Oracle JDK rather than OpenJDK through Ansible is much more troublesome due to licensing from Oracle. I've found some community ...
0
votes
0answers
15 views

What is the name for protocol 1521 (Oracle)

What is the name for the Oracle protocol used by the port 1521? Like TDS (Tabular Data Stream ) 1433 for Microsoft SQL Server.
1
vote
0answers
25 views

Oracle will not start after VM crash

My Oracle 11gR2, running on a VM, crashed when the datastore of the host filled up. I got the VM to start and as I'm trying to start the DB, I see this: Connected to an idle instance. SQL> startup ...
0
votes
1answer
34 views

Trouble adding CNAME record for WAF to a hostname that already has an A record

I have a domain (for instance, example.com) that points to certain IP direction (type A record), and DNS system is controlled by my organization. Now, a new web app has been published at news.example....
0
votes
0answers
17 views

application establishes LDAP bind with version 2, when its hardcoded in code to only call version 3

we have a java based application that connects to customer´s LDAP lookup server. Customer wants to get rid of any bind requests to version 2. So our R&D updated the option in the code as per ...
0
votes
0answers
12 views

"subscriber -54320 create failed" message when connecting to Oracle DB via cx_Oracle

I have some code that is connecting to an Oracle DB via the cx_Oracle python module. When I run the query it finishes successfully, however I see the message "subsciber -54320 create failed" ...
0
votes
0answers
45 views

Oracle's sqlcl ORA-01005: null password given; logon denied on new RHEL8 install, but not nearly identically configured old RHEL7

ON RHEL7... $ sql bagsbx1/password@jdbc:oracle:thin:@mydbdev.dacracot.org:1521/bagdev.dacracot.org SQLcl: Release 20.3 Production on Thu Sep 30 07:06:15 2021 Copyright (c) 1982, 2021, Oracle. All ...
0
votes
0answers
11 views

nginx reverse proxy for oracle apex cloud application

I would like the url below to be the proxy for my oracle apex application url which is very long and not friendly. https://myapp.mydomain.com --> proxy for https://verylongstring.oraclecloudapps....
0
votes
0answers
13 views

How to assign ipv6 address to the secondary vnic in oracle cloud

Running OS Ubuntu 18.4 How can i assign ipv6 address to the secondary vnic, to the primary vnic i can assign to the primary vnic and curl trough but in the secondary it not work. I assign secondary ...
2
votes
0answers
45 views

How to add static IPv6 in Oracle cloud

I am running OS Ubuntu 18.4. I will add static ipv6 address with netplan in Oracle cloud my netplan yaml file looks like this: network: version: 2 renderer: networkd ethernets: enp0s3: ...
0
votes
0answers
49 views

Disk disappeared after umount and reboot

I had a disk which disappeared: # df -h Filesystem Size Used Avail Use% Mounted on . . /dev/mapper/vg1-osblv02 5.0T 61G 4.7T 2% /data/osb-pool-1 /dev/mapper/vg01-osblv01 ...
0
votes
0answers
24 views

Oracle SQL command without input prompt

In Oracle Database I need to execute SQL command RECOVER DATABASE UNTIL CANCEL BACKUP CONTROLFILE;. After that I got input prompt. I should enter CANCEL. Is there a way to enter only one command with ...
0
votes
0answers
17 views

Oracle Cloud - Graceful termination of compute instances in an instance pool

We have an application that we want to run in OCI instance pool and preferably also connect to OCI auto scaling configuration. Whenever a scale-in event occurs, our application is sticky and might ...
0
votes
0answers
16 views

ORACLE Dropping CLOB Column from a very large table

We have a table with about 2 billion rows. ( Yes - billion with a B ). It also has a CLOB column which we want to DROP to reclaim space. Being a production database, we have to ensure : be able to ...
0
votes
0answers
67 views

Oracle : Effect of Stale Partition Statistics on Performance

Our production database tables are range partitioned based on date. Some of the tables and indexes have hundreds of partitions. And some of partitions which are old ( based upon partition key ) have ...
0
votes
1answer
81 views

How to connect oracle database docker image

I have registered with the docker image of oracle database and got below link to pull the image. docker pull store/oracle/database-enterprise:12.2.0.1 No other tags available to see on the page. But ...
1
vote
1answer
21 views

Oracle database - solaris 10 9/10 where is i can find

We have Oracle tech login but cannot find the elusive Solaris 10 9-10 SW load iso file. We have just about everything else for Sol 10 .... and can't restore a an ORACLE DATABASE backup without it to ...
-1
votes
1answer
33 views

Users and Roles Extraction in Oracle

I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this: SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
0
votes
1answer
26 views

PSU Patch on 2 standby database

We have one Primary have 2 standby database... so we planning to PSU patch on Primar and one standby only in that case when we running catundle on primary it any problem for another standby which we ...
0
votes
1answer
110 views

Oracle 18c XE can't backup PDB database after corruption of the main XE database

I have an Oracle 18c XE server where there is a corruption in the system01.dbf file of the main XE database. All user data is in a PDB database which luckily seems ok (the PDB is working in production ...
0
votes
2answers
247 views

Can't assign IPv6 address to CentOS7 VM on Oracle Cloud

I just can't get to assigning a public IPv6 address to my oracle instance running CentOS 7. I have assigned IPv6 range to the subnet, and another VM running Ubuntu successfully gets the assigned IPv6. ...
0
votes
1answer
73 views

Dockerfile Works Locally But Fails on EB (Elastic Beanstalk) Deploy (PHP 7.3 with OCI8 extension)

Good day, fellow developers! I have been searching for 2 weeks now on how to install the OCI8 PHP extension on Elastic Beanstalk using .ebextensions but sadly I can't search for similar ones. Before I ...
-4
votes
1answer
36 views

Oracle too much processes [closed]

My oracle server has a huge queue and slowly executes user requests. I have increased ram and cpu but still same problem. I dont know anything to oracle, can you please give me commands to check if my ...
-1
votes
2answers
57 views

Best Practice: Add an Additional Disk to Expand Logical Volume or Expand Existing Disk

We host a client’s Oracle VMs on our Nutanix platform. To date, whenever their VMs require more space they have us add an additional vDisk which they then add to the VG in order to expand the required ...
1
vote
1answer
628 views

Oracle Cloud Control 13, Cannot connect to Weblogic admin server

Recently I have performed a fresh installation of Oracle Cloud Control 13.3. The first thing I have noticed was that the Weblogic admin server appears to be down according to Cloud Control. When ...
1
vote
1answer
864 views

How to open all ports in Oracle Linux 7?

I'm trying to set up a Outline VPN server on my Oracle Cloud Instance. However I keep getting the error You won’t be able to access it externally, despite your server being correctly set up, because ...
0
votes
0answers
34 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 &...
0
votes
1answer
398 views

Can't ssh into an oracle database on Oracle Cloud Integration

I created the database using terraform with the following database system: resource "oci_database_db_system" "test_db_system" { availability_domain = data....
1
vote
0answers
80 views

Why does LDAP work only for 64 bit but is slow for 32 bit? Why did my 1 line SQLNET.ORA change fix my issue?

I have two Oracle 12.1 clients installed on my laptop, a 32 install and a 64 bit install. The configurations were the same for both. My SQLNET.ORA file was set up to specify to first use OID and then ...
0
votes
0answers
24 views

Extract and Insert data into Oracle Autonomous Data Warehouse by Google Data Fusion or DataProc

We're trying to figure out how to connect our GCP Data Fusion or DataProc in Oracle Cloud Infrastructure Autonomous Data Warehouse to extract and insert data between OCI and GCP. I have the ADW ...
0
votes
1answer
28 views

"User Not Found" message after logging in to Oracle Retail Central Office application

Application Version- 12.0.9 Problem- After logging in to the oracle retail Central office application, I am getting "user not found" message on the screen even though my user has been added ...
1
vote
0answers
39 views

Packet Loss between server-to-server Oracle Linux 7.9 bond

I have 2 Oracle Linux 7.9 physical servers, each one with a dual nic. I bonded this dual nic end attached server-to-server with 2 cables (not crossover cables). I have packet loss in average 50% ...
1
vote
0answers
29 views

How to check HP UX rx2660 shutdown log

I have beginner experience in Unix servers and I want to know how to check HP UX rx2660 shutdown log in case of abnormal shutdown. Another question: Is there the shutdown command send anyway when UPS ...
0
votes
1answer
201 views

How to setup primary DNS as OCI DNS and secondary DNS as EasyDNS?

I want to setup primary DNS as OCI DNS for a domain example.com. Want to setup it's secondary DNS in easyDNS. I found a documentation here to setup secondary DNS with easyDNS: https://kb.easydns.com/...
2
votes
1answer
324 views

Accidentally turned my RHEL installation into an Oracle one. How do I change it back?

I successfully managed to install an Oracle database on my server (if such I thing should be considered a success). However, the way I did it had the unfortunate side-effect of making lsb_release ...
0
votes
1answer
523 views

Connect Oracle Autonomous Database in Microsoft Azure Data Factory

Anyone in here have already connected Oracle Autonomous DB in Azure Data Factory? We are trying to implement some data copies from SQL Server to Oracle, but I am not able to reach Oracle Autonomous ...
1
vote
1answer
186 views

Integration of Azure with Oracle Cloud Infrastructure (OCI) ORA-03113: end-of-file on communication channel

I'm trying to integrate Azure and OCI using this approach and this article. Now, I have the infrastructure up and running. It consists of a VM in Azure, an Autonomous Database (ATP) Oracle Cloud ...
1
vote
1answer
805 views

xRDP fails on Ubuntu Server 20.04 in Oracle Cloud VM instance and ubuntu-desktop installed

I am running into a problem where xRDP fails to respond to any RDP requests sent to a VM instance running in OCP under Ubuntu Server 20.04 with GNOME GUI installed (via sudo tasksel install ubuntu-...
0
votes
0answers
908 views

Connection timed out (FRM-92103) with Oracle Forms 11g on Azure Windows Virtual Machine

We are running an Oracle database 19c with Oracle Forms 11g on Azure Windows VM. Our config is as follows: Azure Windows Virtual Machine Standard B4ms (4 vcpus, 16 GiB memory) Public IP address with ...
2
votes
1answer
1k views

Connection issue (ORA-03135) with Oracle database on Azure Windows Virtual Machine

We are running an Oracle 19c database on Azure Windows VM. Our config is as follows: Azure Windows Virtual Machine Standard B4ms (4 vcpus, 16 GiB memory) Public IP address with an "idle timeout&...
0
votes
1answer
58 views

Oracle Database Realtime Sync

Client is using Oracle Database Standard Edition so Active Data guard feature is not available and he wants to have a standby replica of the database which can take over the environment as soon as the ...
0
votes
1answer
323 views

oracle em does not show any administrations options

I want to try some administration tasks on the new version (19) of Oracle database like add a new user or edit user rights on the em. So I downloaded the oracle vm. I tried to connect to oracle ...
-2
votes
1answer
65 views

From ZFS Array CLI how to get the latest snapshot for share

from ZFS Array cli how to get the latest snapshot for share. my share name is "test_share" for this share want to check the latest snapshot. Test-ae0101zfs201:shares test_proj_test/...
0
votes
0answers
850 views

nginx reverse proxy to Oracle ORDS/APEX - how are cookies set?

Using nginx to reverse proxy to Oracle's "Always Free Tier" in Autonomous Database which provides ORDS which connects to APEX in the database. Mainly because Oracle doesn't support vanity ...
0
votes
0answers
738 views

Oracle cloud - ORA-20401: Authorization failed for URI

I'm having a problem with Oracle object storage authentication. I have a user danilo and this user belongs to Administrators group (This group has the ALLOW GROUP Administrators to manage all-...
0
votes
0answers
112 views

I am not able to start an instance of Oracle Database - ORA-00205: error in identifying control file, check alert log for more info

When I want start the server instance I get the following message: SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System ...
1
vote
1answer
926 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 ...
0
votes
1answer
95 views

Getting Error while connecting public to private server on Oracle cloud

ssh -t -o ProxyCommand='ssh -i ~/.ssh/id_rsa opc@0.0.0.0 -W %h:%p %r' -i ~/.ssh/id_rsa opc@0.0.0.0 ssh -t -o ProxyCommand='ssh -i ~/.ssh/id_rsa opc@<publiIP> -W %h:%p %r' -i ~/.ssh/id_rsa opc@...
0
votes
0answers
87 views

Can not find wich process is consuming all memory in Oracle Linux server 7.7

I have a server here wich has an alert of high memory usage (95% of all memory is being used), but i cant find where it is being used. [user@server ~]$ free -m total used ...
1
vote
1answer
37 views

Monitoring Windows Failover Cluster with Enterprise Manager

I'm trying to monitor SQL Server instances on a 2 node active/passive windows failover cluster with Enterprise Manager. Oracle gives the following steps: -Install local agents on both nodes. -...

1
2 3 4 5
17