Questions tagged [oracle]
The oracle tag has no usage guidance.
73
questions
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 ...
