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
1 answer
38 views

Modular Dependency in my Docker "dnf module enabled -y php:7.4 php-oci8"

So I'm running a command dnf module enabled -y php:7.4 php-oci8 but I'm getting a Modular Dependency Problem, this was not an issue before. Problem: module php-oci8:21c:8060020221011134100:34611983....
0 votes
0 answers
35 views

Attaching Public IP address to VNIC in Oracle Cloud instance running Ubuntu 20.04 server

I am running Ubuntu Server 20.04 on an oracle cloud instance. In Ubuntu, When I type ip a it returns the following (showing only my private Oracle IP attached to the VNIC): 2: ens3: <BROADCAST,...
  • 73
0 votes
1 answer
27 views

Oracle 19c database session unstable with Azure Load Balancer

We are trying to implement a HA setup with an Oracle database in Azure, somewhat as described in DBAKevlar's white paper and Oracle HA in Azure - Options. Our setup includes an Oracle Data Guard pair (...
  • 31
0 votes
0 answers
24 views

AWS Oracle RDS showing wrong timestamps for MTIME using rdsadmin.rds_file_util.listdir

We are having problems sorting the files in all our directories in AWS Oracle RDS. Listing the files using e.g. SELECT * FROM TABLE(rdsadmin.rds_file_util.listdir(p_directory => 'BDUMP')); they all ...
  • 5,100
1 vote
0 answers
23 views

Is quorum disk required for standalone installations?

A provider is setting up a single bare-metal Oracle server for us, which will not be part of any grid or cluster. It has over 20 disks connected via fiber to a SAN, each 1TB. OVM is installed on a ...
  • 151
0 votes
0 answers
29 views

When creating a VM, memory keeps filling up, and never finishes installation

I'm using VirtualBox to get started with Oracle Database. I downloaded Database App Development VM and tried to import it into VB, but every time I try, it stops with the error [0x80070057]. I read ...
0 votes
1 answer
135 views

Access from one network to another through cloud WireGuard server

Please need your help with WireGuard & network configuring. I am trying to get access from Office network to Field network through Oracle Cloud WireGuard server. Please take a look on the picture. ...
  • 11
0 votes
2 answers
67 views

Oracle cloud - Connect to Windows instance with disabled ethernet

As I was troubleshooting the network connection of my Windows instance, I managed to disable the OCI Ethernet adapter, which makes it impossible to connect to the instance through RDP. I've have ...
1 vote
0 answers
116 views

Tunneling a LEMP server through an oracle instance with wireguard. Cannot get Nginx Certbot certificates on LEMP server. How to debug?

I have a LEMP server at home running Ubuntu 22.02 and an Oracle cloud instance running Ubuntu 20.04. The Oracle cloud instance is acting as a Wireguard server. The LEMP server at home is acting as the ...
  • 73
0 votes
0 answers
215 views

Can't select 4Core/24GB in Oracle Cloud Free Tier

My Oracle Cloud account is showing my Free tier available quotas here 4 Core/24 GB But when I select 4 Core/24 GB, it's warning "Service limits status" I can only select 3 Core/18 GB. I ...
0 votes
0 answers
18 views

Installation of hypervisor on Linux server

Do you know if it's possible to install VirtualBox or VMware Sphere hypervisor on the Oracle Linux Server 7.9?
0 votes
0 answers
26 views

Cross region backup (block & boot volumes) naming convention - Oracle OCI

I have 4 instances in ap-mumbai-1 region with 1 block volume attached to each of them. I have configured a cross region backup policy to ship the backups to ap-osaka-1 region. But in ap-osaka-1 region,...
0 votes
1 answer
50 views

Instance in OIC lost public IP

I have two instances in OIC free tier. I saw that I cant connect to either server with SSH. I logged in to web ui and see both instances running, but they lack Public IP. These IPs where assigned at ...
0 votes
0 answers
212 views

Are the instances in different subnets of same VCN directly accessible by each other in OCI?

In Oracle cloud infrastructure, Let's say I have a VCN with IPv4 CIDR Block: 10.0.0.0/16. That VCN has a public subnet with IPv4 CIDR Block: 10.0.0.0/24. If create a private subnet in the same VCN, ...
  • 125
0 votes
0 answers
32 views

Oracle DB "The pipe has been ended" error when Connection Pooling is enabled

I have a problem with an Oracle instance when connecting to it, it throws a "The pipe has been ended" error. The server that connects to the db can create quite a lot of connections when ...
  • 123
0 votes
2 answers
122 views

Oracle Cloud Native Environment setup with Vault faild on validating host names in certificate

I'm setting up OLCNE environment with Hashicorp Vault PKI, I successfully install agent, setup vault, certificates was generated but during module createion I have error that host name not match ...
0 votes
1 answer
396 views

ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to setup a connection from my rhel 7.9 machine to my oracle host db on windows server 2016 running oracle 19c. 04:25:36 - ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the ...
0 votes
0 answers
455 views

Compatible way to bind to 169.254.169.254?

I have an application which I can't change, running in a docker container on a bare metal server (no cloud environment) It tries to connect to 169.254.169.254 (fetching IMDSv2 metadata). This ip / the ...
0 votes
1 answer
285 views

Unable to connect to Oracle database 21c

I have fresh Oracle Linux with Oracle Database 21c installed on it. Issue is I cannot connect to it from the outside, locally there is no problem. lsof was showing that port 1521 was open only for ...
0 votes
1 answer
149 views

SQL Developer PL/SQL script fails to display output over OpenVPN after running a certain amount of time

The Problem: When I try to run gather stats over OpenVPN on my Oracle 19c database, SQL Developer doesn't return the typical "PL/SQL procedure successfully completed" message if it runs for ...
  • 3
0 votes
1 answer
58 views

Installing Oracle Java in Red Hat Enterprise Linux

I am seeking advice on a solution for updating Oracle Java in a large number of hosts - We have a large number of RHEL hosts, and we would like to use yum update rather than rpm install for upgrading ...
0 votes
0 answers
40 views

Is it required to install Oracle Client before installing OracleDataAccessComponents and OraOleDB?

I have a Windows Server 2019 intended to be a web server IIS running ASP.Net MVC applications that store data on Oracle 10g database. The apps were developed on 32bit machines, and rely on existence ...
0 votes
1 answer
2k views

Oracle cloud compute change ssh port fails

I am new to cloud computing and plan to use an always free compute service from Oracle Cloud to obtain a public IP address to run a website. As a basic security measure I require my machines to not ...
0 votes
0 answers
17 views

Oracle 19c: EM console issue

On a non-CDB installation I have port 5500 configured as I see using the command: select dbms_xdb_config.gethttpsport() from dual; ...and yet the server is not listening on port 5500 as I see with ...
  • 11
0 votes
0 answers
66 views

Oracle Cloud to Power BI service using Azure VPN connection

Hello and hopefully someone has experience with PowerBI cloud datasets I am looking for a way to use Oracle Cloud (cloud, not on-prem) as Power BI dataset (web version, not desktop). It is able to use ...
1 vote
0 answers
214 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 ...
  • 35
1 vote
0 answers
93 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 ...
  • 11
0 votes
1 answer
117 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....
1 vote
0 answers
197 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
0 answers
733 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 ...
  • 123
0 votes
1 answer
617 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 ...
  • 399
1 vote
1 answer
86 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
1 answer
254 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
1 answer
34 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
1 answer
219 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
2 answers
612 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
1 answer
116 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
1 answer
110 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 ...
  • 282
-1 votes
2 answers
253 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
1 answer
2k 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
1 answer
2k 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
0 answers
92 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
1 answer
1k 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
0 answers
140 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 ...
  • 95
0 votes
1 answer
35 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
0 answers
101 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% ...
0 votes
1 answer
348 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/...
  • 125
2 votes
1 answer
563 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
1 answer
765 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
1 answer
256 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
2 3 4 5
17