Questions tagged [oracle]
The oracle tag has no usage guidance.
71
questions
0
votes
0
answers
11
views
mounting windows to linux using cif utils : SOA unable to access the mounted directory
Here I'm trying to write file to a target mounted directory using oracle soa. However, on writing file I got below:
Exception occurred when binding was invoked.
Exception occurred during invocation of ...
0
votes
0
answers
27
views
Exception in thread "main" java.lang.UnsatisfiedLinkError
Context:
Trying to install Oracle WebLogic Infrastructure 12.2.1.4.0 on Oracle Linux 8.5. JDK 7 & JDK 8 are installed.
Issue:
2
votes
2
answers
380
views
How to store query multiple result in shell script variable(Array)?
I'm trying to do a query and store every row result in an array element in ksh (maybe bash).
I do:
result=($($PATH_UTI/querysh "
set heading off
set feedback off
SELECT columnA,columnb FROM user....
0
votes
1
answer
72
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
1
answer
183
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
0
answers
54
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
1
answer
57
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
2
answers
910
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
0
answers
20
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
2
answers
2k
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
1
answer
65
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
0
answers
127
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
1
answer
256
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 ...
1
vote
0
answers
29
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
1
answer
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
1
answer
57
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
1
answer
221
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
3
answers
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
1
answer
52
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
1
answer
98
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
1
answer
232
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
0
answers
280
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
1
answer
1k
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
3
answers
301
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
1
answer
303
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
1
answer
3k
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
0
answers
107
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
0
answers
62
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
2
answers
2k
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
1
answer
104
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 = ...
1
vote
1
answer
5k
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
0
answers
47
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
1
answer
478
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
1
answer
253
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
0
answers
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
0
answers
68
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
1
answer
741
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
1
answer
198
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
2
answers
142
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
1
answer
6k
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
1
answer
530
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
1
answer
573
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
1
answer
454
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
3
answers
436
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
2
answers
445
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
1
answer
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
1
answer
401
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
1
answer
614
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 ...
0
votes
1
answer
1k
views
text based browser with javascript support [closed]
What I want to ask is purely for educational and learning purpose.
I am trying to download and install Oracle 11g R2 on a CentOS 7 system in text mode. The text based browsers I tried are lynx, links,...
1
vote
2
answers
713
views
SLES 12.3 and oracleasm module issue
So...
Fresh installation of Sles 12.3, kernel 4.4.73-5-default, x64, Oracle support packages installed using zypper from official SUSE repositories...
~:rpm -qa | grep orac
oracleasm-support-2.1.8-1....