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
14 views

Oracle Database systemd service: ORA-01031: insufficient privileges

I'm having troubles starting an oracle database with systemd. The start and stop script was created in /home/oracle/scripts/ oracledbstart.sh: #!/bin/bash export ORACLE_HOME=/opt/oracle/product/11.2.0....
0
votes
0answers
31 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 ...
-2
votes
0answers
15 views

Sun Oracle X3-2L Server How to firmware Update?

I am using / trying oracle x3-2l server but firmware update not find files. I can't using oracle support. How to firmware files download and updated? Please help me.
0
votes
0answers
13 views

Oracle12c standard edition SNMP monitoring

I have Oracle12c "standard" edition database running. I would like to enable SNMP to monitor this database. All the documentation I found so far pointing that I need "enterprise edition&...
0
votes
1answer
43 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 ...
0
votes
1answer
65 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
135 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
107 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
96 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
13 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
0answers
12 views

how to deploy multiple oracle db scripts using jenkins

I have just started using Jenkins and would like to implement as mentioned below - I want to pass directory name to shell script and then execute all .sql scripts inside that directory using jenkins. ...
0
votes
1answer
28 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
34 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
144 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
54 views

windows 10 installing oracle client 12c, 18c or 19c hanging at step 4

I am trying to install Oracle Client version 12c, 18c or 19c. I have tried both of the installers, and once I perform prerequisite checks on step 4, it hangs and won't proceed any further. Same thing ...
0
votes
0answers
32 views

Oracle RAC 19c Backup to NFS Failing

I have mounted the NFS share on Oracle RAC Machine with the following options: rw,bg,actimeo=0,hard,timeo=600,nolock The NFS Server Export: rw,no_root_sqash,no_all_squash,secure. The directory where ...
0
votes
0answers
144 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
53 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
256 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
37 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
41 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
25 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. -...
0
votes
0answers
11 views

Integrate Azure ADDS with Oracle Cloud Infra

I have below use-case - Currently in my OCI infra one of the region datacenter is using RW AD domain controllers which further going to connect customer tenancies through VPNs and each customer ...
0
votes
0answers
84 views

Adding values to server start arguments oracle weblogic

Oracle has suggested to add few parameters to server start arguments which we are adding at Managed server -> configuration -> server start -> Arguments. Now i need to make this changes in more than ...
0
votes
1answer
105 views

How do I enforce encryption in transit with AWS RDS Oracle using CloudFormation YAML?

How do I enable and enforce / mandate encryption in transit for AWS RDS Oracle instances, when setting up the RDS database using CloudFormation YAML.
0
votes
0answers
28 views

azure oracle linux default password username

Does anyone know what the pass/user after typing sqlplus is for Azure cloud? The defaults oracle/oracle not working. Also, how to import sql script files aside from upload to github then downloading?
0
votes
2answers
60 views

Only oracle user can run sqlplus

I have a couple of RHEL 6 boxes with Oracle 12.2 server and 11.2 client. This is the vendor requirement. On one server I can run sqlplus as any user, on the other server I can only run sqlplus as ...
0
votes
0answers
209 views

Error "Exception [java.io.IOException:IO Error:There is no process to read data written to a pipe.]

We see this error in our environment, and thinking of the below mentioned as a workaround solution. If any of you have see this error in your experience or have an idea of such exception errors , ...
0
votes
1answer
91 views

access oracle enterprise manager from client

Somebody can tell me how to enable oracle enterprise manager to access from a client? I install Oracle Express 18.4.0.0.0 in a Centos 7 vm. Now I access to oracle em by browser on url https://...
0
votes
1answer
49 views

Oracle Cloud stopping due to inactivity

I have an Oracle Cloud Autonomous Database running in the Free Tier. Occasionally the database stops. When viewed on the website, the details say that it was stopped due to inactivity. However, that ...
0
votes
0answers
23 views

Do I have to purchase java license to use Jenkins? [duplicate]

We are using Jenkins to build and deploy apps to production and staging. While migrating our Jenkins Servers to a newer server, we have realized that apparently Java RTE now requires a license to use. ...
1
vote
0answers
123 views

Oracle reports SMTP change

We recently migrated our SMTP address from smtp.old.example to smtp.new.example, this caused our Oracle reports server to stop sending emails which was expected. I have updated the <pluginParam ...
0
votes
0answers
1k views

How to install PHP 7 on Oracle Linux?

I have Oracle Linux 7.7 instance on Oracle cloud. I want to install PHP 7.2 on it. Previously I have installed PHP 7 on different Linux flavors but I could not find proper documentation, tutorial or ...
0
votes
0answers
54 views

Sum of bytes of database files of oracle database is showing more than the physical used size of the mount point

We are having oracle 11g2 database on Solaris 10. We have all data files under single mount point say /u001 and we make the sum of bytes of all data files which is more than the physical used size of ...
1
vote
0answers
31 views

How to authenticate a Linux User against Oracle Windows NTS?

We are using NTS for our Oracle Windows on a Windows Server 2016. Adding domain users to the ora_dba group works if we want to connect remotely as System Administrator. But is it possible to ...
0
votes
1answer
63 views

OS recommendation for Oracle XE on a virtual machine? [closed]

I'm after advice on the best way to proceed, still new to some of this: I'm looking into deploying a virtual machine solely for handling a copy of oracle database XE on it. Currently we are solely ...
-1
votes
1answer
96 views

Install FREENAS on ORACLE SUN SPARC T5240

is possible to install FreeNas server on Sun Sparc Enterprise T5240 (Hardware compatibility),and how to do that? Thanks
1
vote
1answer
236 views

Installing Solaris 10 on Sun oracle SPARC Enterprise T5220 and Sun oracle SPARC T4-1 server

I m newbie to sever environment.I got old Solaris 5.10 already installed following severs Sun oracle SPARC Enterprise T5220 Sun oracle SPARC T4-1 server It does not show BIOS loading ,when it is ...
0
votes
1answer
1k views

Java installation error on Debian 8

I followed the instructions from this website: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-debian-8 When I install jre and jdk it says: Reading package lists....
1
vote
1answer
971 views

Oracle JDK is no longer available/downloading from the webupd8team

I had been depending on ppa:webupd8team/java to provide the apt package oracle-java8-installer. The packages are no longer present: http://ppa.launchpad.net/webupd8team/java/ubuntu/dists/ What ...
0
votes
1answer
54 views

Incorrect Oracle host

I have an issue with oracle 11g installed on a Windows Server 2016. When I create a new DB the hostname is always as the following image shows. https://i.stack.imgur.com/59Eg4.png However, my ...
0
votes
1answer
114 views

Synchronize Oracle database on VM under KVM using DRBD

We have two physical servers and we want to use KVM to create some VMs. One of the VMs will contain an Oracle 12 database and we want to make it highly available. We thought of using DRBD to ...
0
votes
3answers
900 views

oci_connect(): Error while trying to retrieve text for error ORA-28547

I have this connection string on an older server which works fine and connects to a remote oracle server. On this new server I installed oracle instant client simple and devel and php pecl oci8. ...
0
votes
2answers
2k views

Escape all characters that shell or sqlplus need escaped in any password given

You may try for yourself by creating this user: CREATE USER "karl" IDENTIFIED BY "/?'!@#$%^&*()_+=-~`" (Maybe there are other symbols I should have included for my testing, but that seemed ...
1
vote
2answers
3k views

AWS Database Migration Service requires a role not mentioned in documentation

I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the ...
2
votes
0answers
85 views

ipnat.conf rdr won't work solaris 10

I'm currently trying to achieve the following from the ipnat.conf configuration file on solaris 10: I need my server to act like proxy between two specific hosts (with specific ports). Lets say hostA ...
2
votes
1answer
240 views

Exit sqlplus on error but not warning

We have a script that deploys code to our database as part of our application deployments. Currently, if a view or package errors, it ignores that error and moves on. We want it to fail at that point ...
2
votes
0answers
157 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
1answer
253 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
175 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, ...

1
2 3 4 5
17