Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
40 views

Oracle Linux or Ubuntu Server as a hypervisor?

I own a HP Proliant DL380 Rack Server. I would like to use it as a hypervisor for a production environment. I was thiking of installing CentOS with KVM on it, but unfortunately CentOS is not realiable ...
2
votes
0answers
62 views

Install oracle on an AIX VM virtualizing with QEMU

I installed a Linux VM in the virtual box, and inside it I installed the QEMU package and virtualized an AIX 7.2 image. The entire installation went correctly. But when I try to install an Oracle ...
0
votes
0answers
15 views

Oracle Linux - "dzdo yum update yum" and "dnf module list" not working and showing timeout error

dzdo yum update yum Total download size: 2.9 M Is this ok [y/N]: y Downloading Packages: ^[OC(1-3/7): dnf-4.4.2-11.el8.noarch.rpm 0% [ ...
0
votes
1answer
19 views

Oracle Linux 6.7 - Nohup: Argument list too long

There are 1 million directories and some files in directories (.pdf, .csv etc.) under the path I have specified below: /data/upl/repo/exp/ I want all files and folders older than 1 year to be deleted,...
0
votes
2answers
148 views

"python: command not found" on Oracle Linux 8

I have previous had no problem building a mirror server with Oracle Linux 7. I have followed the same steps registering the server, adding subscriptions. When I later run ./uln-yum-mirror script I ...
0
votes
0answers
19 views

Error when installing oracle database rpm

I am getting an error when I try to install the oracle rpm. I tried to fix it using --nodigest but it says file not found.
2
votes
2answers
510 views

Oracle Free Tier: Wireguard and iptables

Problem: Traffic not making it from "client" to "server" and back. Configs: "server": [Interface] Address = 10.8.0.1/24 ListenPort = 51820 PrivateKey = [redacted] PostUp ...
1
vote
1answer
33 views

How do I resize image jpg/png files in AIX based systems through linux commands (Not UNIX)

How do I resize image jpg/png files in AIX based systems through linux commands (Not UNIX). I have already seen ImageMagick tool in many forums but it's only for unix based systems like ubuntu but it ...
0
votes
0answers
51 views

is it applicable to install oracle db 19c on pacemaker cluster?

I want to install oracle 19 c on an RHEL Cluster. I configure 2 RHEL 7.7 with pacemaker cluster and all is working well for VIP IP and shared disk. Is it applicable to install the oracle database on ...
0
votes
1answer
93 views

Trying to install Ora2pg

I am on an Amazon EC2 server running RHEL. The version is: NAME="Red Hat Enterprise Linux" VERSION="8.3 (Ootpa)" I am trying to install Ora2pg (it is based on Perl). But I'm ...
0
votes
0answers
109 views

Black Screen when starting CentOS 8 on VM

I downloaded Oracle VM VirtualBox 6.1 and CentOS 8.3 today. After completing the steps to configure the VB for the CentOS, I clicked the "Start" button. The Oracle VM VB showed up with a ...
0
votes
0answers
81 views

High CPU usage due to ora_dia0_orcldev background process

We have an HP DL 380 server having 32 cores (2 threads per core) and a total RAM of 128GB. Installed OS is RHEL 6.4. We have oracle (version 11g) installed onto this server. Multiple oracle background ...
1
vote
0answers
26 views

Cannot ChooseWhere to Install the Software and Configuring Storage: Installing oracle linux 8.3 on expired windows 7

I have created a bootable oracle linux 8.3 hard disk and restarted my windows machine by booting from the bootable hard disk which has oracle linux 8.3 iso. It went well until this stage, where is it ...
0
votes
0answers
8 views

CxOracle Insert Query Taking too long

I am trying to insert about 60k records into an Oracle DB using cxOracle from python. Earlier the records used to inserted very fast, however now it takes about 9m for every 100 records. I am ...
0
votes
0answers
26 views

Linux: Disk Size increases suddenly /dev/md/ora01/dsk/d100 and then decreases itself

Disk Size increases and suddenly decreases: df -h gives following /dev/md/ora01/dsk/d100 309G 292G 14G 96% /global/data01 When i try to go inside the path then i get ...
0
votes
1answer
26 views

Pass Linux variable in Oracle script

How to pass Linux variable in Oracle code? I need to pass it in below format and it should not ask for "enter a value for 1:" Please advise. mount='/u08/dbname/' sqlplus -s "/ as sysdba&...
-1
votes
1answer
47 views

Pass a linux variable into oracle script [duplicate]

I am trying to pass mount_point details in my oracle script. I am able to pass integer variable using below code but not able to send mount point details in oracle script: sed "s/@@pqr@@/$space/g&...
0
votes
0answers
141 views

How to open oracle xe GUI in linux?

I have installed oracle xe 19c database on oracle linux 8 using yum -y install xxx.rpm method. I know that there is one more step to do for oracle xe 18c, I should run /etc/init.d/oracle-xe configure. ...
0
votes
0answers
86 views

Why virtual box disc can't be shrinked, when I specify the correct directory of my vm image?

this is my virtual box installation dir. C:\Program Files\Oracle\VirtualBox and this one is where my image (linux.vdi) is located. C:\Users\hmkhitaryan\dev\vm\linux Now I want to add disc size to my ...
0
votes
3answers
2k views

SSH return code status and error handling

I want to check if files count is 0 on Remote server using ssh. Below code is only checking if file (ending with .dmp exists ) if ssh v0021x91 ls /apps/oracle/home/DB_1201/*.dmp then echo &...
0
votes
1answer
34 views

Enabling Huge Pages on RHEL6 for Oracle 18C xe

I have been trying to switch from oracle AMM to ASMM huge pages. I have done the following changes on RHEL 6 Added following entry in /etc/sysctl.conf ( as suggested by hugepages_setting.sh ) ...
1
vote
1answer
73 views

Oracle Linux logon screen without login box

today my Oracle Linux Server 7.3 (installed on a Proxmox VM) just shows a gray window, where normaly the login prompt would be. The gray background is the regular "noisy" Oracle Server 7 ...
0
votes
1answer
176 views

Running a .sh script with crontab [duplicate]

I have a file named diario.sh that I run manually using ./diario.sh The script file contains the following: #!/bin/bash cd /home/etapa/Scripts echo "@CDRS_ETAPATOTAL.sql" | sqlplus -s ...
0
votes
0answers
204 views

Unable to boot Oracle Linux in Virtual Box

I hope this is the right place to ask this question. I'm trying to install Oracle Linux 8.1. It works but then the reboot needed after the installation takes it back to the installation screen. It ...
1
vote
1answer
938 views

Inserting into a Oracle table from a shell variable storing thousands of values

I'm trying to insert records into a column in Oracle where the values are passed from a shell variable. The variable itself stores pattern generated from a list of files. This pattern is generated on ...
4
votes
3answers
243 views

Is there any UNIX V7 certified operating system?

I was just having a look at The Open Group official register of UNIX Certified Products, and it doesn't list any system to be registered for the UNIX V7 brand. Nevertheless, I did remember that Oracle ...
0
votes
1answer
215 views

Unix command substitution when using sqlplud

Trying to invoke a sql file from unix shells script. ExecuteSql1.sh #!/bin/sh ## steps to get the connection and form it. result=`sqlplus -S ${connectURL} << EOF SET PAGES 0 lines 800 @ /sql/...
0
votes
1answer
2k views

Can we install Oracle Database on Windows Subsystem for Linux

I tried to install Oracle Database on Windows Subsystem for LINUX and when i tried to execute command ./runInstaller following error occured ERROR: Unable to verify the graphical display setup. This ...
0
votes
0answers
54 views

Convert 2 HTML file which is output from SQL query into 1 main HTML output file in shell script

In shell script, I used 2 different SQL query & output of these 2 files in HTML format like (eg- ab.html, cd.html). Before DML operation 1 SQL query will run then after DML operation another query ...
0
votes
0answers
42 views

Oracle JDeveloper install ERROR: Cannot locate the archive

I am trying to install Oracle JDeveloper Studio on a CentOS Virtual machine. I have downloaded the install .bin and .zip files using my user. I then tried to change the owner of the file to oracle as ...
1
vote
2answers
1k views

What does this error mean? AH01215: Schema .myuser@mydb. Password .mypass [closed]

I'm trying to deploy a page called 'Create' on my Redhat 7 linux web server using Apache. When I try to reach my page, I get the following error message from my error log: [cgi:error] [pid 23367:tid ...
2
votes
1answer
70 views

Add lines using sed matching two line

I have a file like below SID_LIST_LISTENER_DG = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DRCDBDB_DGMGRL) (ORACLE_HOME = /ofa/u1002/18C_DB_HOME) (SID_NAME = ...
0
votes
1answer
4k views

Can we connect to oracle database using python without cx_Oracle in Linux

Can we connect to oracle database using python in linux without "cx_Oracle" library. We have a restriction of installing "Oracle Instant client which is mandatory required for cx_oracle library" . We ...
1
vote
0answers
42 views

weblogic cluster between two different server

I have two server (for example 1.1.1.1 , 1.1.1.2). I want to have one administrator tools and two managed servers (one on 1.1.1.1 and another on 1.1.1.2) and cluster these two nodes. Is the base of ...
0
votes
1answer
395 views

To print log file with out put of cron job scheduled for a sql block - with Date and time (all the executions of cron)

I have a shell script which executes a pl/sql block, I'm printing output to output file but it's not keeping old information and not displaying time and date when the script was executed. My script ...
0
votes
1answer
209 views

Change hostname in tnsnames.ora file

I'm trying to write a script to update just the hostname in the tnsnames.ora file. I'm needing the entry to work case insensitive. For example ${DBNAME} is lowercase database name and in my tnsnames....
2
votes
0answers
5k views

E: Unable to locate package oracle-java8-installer

I've been using the below Dockerfile to install java8. However, all of a sudden while creating the docker image it breaks with error E: Unable to locate package oracle-java8-installer E: Unable to ...
1
vote
0answers
60 views

Setup OpenLdap on Oracle Linux 6

I am currently trying to setup an openldap server on an Oracle Linux 6 VM (VirtualBox). Packagemanager yum installed openldap version 2.4.40-16. Following this setup guide: https://docs.oracle.com/cd/...
2
votes
1answer
726 views

Install Java command line - webupd8team PPA DISCONTINUED

Java can't be installed from webupd8team PPA since the Oracle JDK License has changed for releases starting April 16, 2019: https://launchpad.net/~webupd8team/+archive/ubuntu/java Oracle Java ...
0
votes
1answer
170 views

oracle 11g installation on ubuntu 16.04 sysctl permission denied?

I am trying to install oracle 11g on ubuntu 16.04 after setting oracle 11g xe kernel parameters successfully # Oracle 11g XE kernel parameters fs.file-max=6815744 net.ipv4.ip_local_port_range=...
0
votes
2answers
120 views

Why does my hostname show as "Unknown-08-00-27-50-25-08" when using a bridged connection?

I am running an Oracle Linux 7 VM. I have booted the VM up separately with different network options, NAT and Bridged connection. I would like to use a bridged connection so I can SSH in easily. When ...
-1
votes
1answer
5k views

how to enable GUI mode in oracle linux 6

WE are trying to opening Graphical user interface services , but not able to open in Oracle Linux 6.10. Please provide any solution how to enable GUI mode in oracle linux 6.1 .
0
votes
1answer
465 views

Oracle Linux 7 mounting SAN storage issue

I have a scenario where I am trying to mount SAN storage to my linux machine. My environment details are- Oracle VM manager for VM creation Fiber Channel HP3PAR SAN storage attached as physical disk ...
0
votes
1answer
499 views

Solaris 11 change current image / "entire" package

I need to install a new Solaris image on our server as it used to be under a support agreement but is not anymore, and as such I'm unable to download any new packages from the (https://pkg.oracle.com/...
0
votes
1answer
405 views

How to compile a ".pc" file on Debian 9?

I need to compile a Pro*C - .pc file on Ubuntu. So far what I have realised is that I need a Pro*C compiler to translate the Pro*C - .pc file into pure / standard C code.  But I need to have Oracle ...
-1
votes
3answers
394 views

Can I change the SHELL on a running Oracle database?

I just started a new contract and have run into an issue I have never encountered before. Their Oracle database was started under a korn shell. oracle:x:500:100:Oracle user:/home/oracle:/usr/bin/ksh ...
0
votes
2answers
391 views

Install Java 6 from Oracle to Debian Lenny

Since Java 6 is not available in Debian 5 I decided to take it from Oracle. I have downloaded Java 6 SDK in file jdk-6u45-linux-i586-rpm.bin. But how to install it? I executed jdk-6u45-linux-i586-rpm....
2
votes
1answer
2k views

editing sysctl.conf on oracle linux 7.5

I am going to install oracle database 12c on oracle linux 7.5. In the process, I have to edit following kernel parameters and set values. fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = ...
0
votes
1answer
351 views

cron reschedule seems not to be taken into account unless reboot occurs?

I have read a number of posts on SE.com regarding cronjobs, crontab, and how to reschedule cron jobs. But it seems that, in my Debian environment, a session cleanup job schedule simply called "php", ...
0
votes
1answer
578 views

Execute a block based on the output of a variable [closed]

Below is the script i drafted, that will work based on the SIDs it will get from ps -ef | grep pmon Once the SID is grepped, it will pass the SID to dbenv() to set the necessary parameters, and it ...