Questions tagged [oracle]
The oracle tag has no summary.
86 questions
0
votes
0
answers
55
views
SSH Timeout when trying to connect to Oracle Cloud
I made a Compute Instance with Oracle Cloud because I'm trying to run a python code 24/0. I have tried connecting to it all day with no results. Here's what went off in the PowerShell:PS C:\Users\...
3
votes
0
answers
50
views
OracleDB: Encrypt Connection Descriptor In Network Communication
I have recently dumped the network traffic from my application server that talks to my Oracle database server.
I configured the Oracle DB server to encrypt the data using TLSv1.2 when sending over the ...
- 165
0
votes
0
answers
139
views
qcow2 with only grub2 BIOS installed not loading in public cloud, works in qemu though
I am trying to create a simple 200 M new qcow2 with just the grub2 BIOS mode installed in it. My objective is to get to the grub prompt or grub rescue prompt when i load the said qcow2 image in public ...
0
votes
0
answers
236
views
Is it at all possible to use less than 50 GB for an instance boot volume?
I want to create an Oracle Cloud Compute Instance that uses less than 50 GB of space. I only need about 10 GB.
Most information I'm finding on the Internet states that the boot volume on OCI can not ...
- 818
0
votes
0
answers
571
views
yum not updating packages, process times out
I have an Oracle Linux server that was originally installed at OEL7. Recently, it was upgraded to OEL 8. The repos are hosted on a Red Hat Satellite server. Other OEL hosts are not presenting this ...
6
votes
1
answer
1k
views
How to specify dynamic "Environment" variables in a systemd unit file?
This $(ls -d...) does not work in a systemd unit file:
[Service]
Type=forking
Environment="ORACLE_HOME=$(ls -d /usr/lib/oracle/*/client64 | sort -rV | head -n1)"
Environment="TNS_ADMIN=$...
- 2,033
1
vote
0
answers
132
views
Error while trying to install Solaris in VirtualBox
Hello i tried to install Solaris on virtualbox but after i choose instalation method in grub it is stuck at this
I dont know how to fix it. Can someone help me?
Thanks
0
votes
1
answer
67
views
Rescue data on Oracle Cloud after "chmod 700 -r /"
I'll preceed by saying I'm a novice in unix, I use Oracle Always Free for small personal projects. Also this is me trying to save the data specifically on Oracle Cloud.
I accidentally ran sudo chmod ...
0
votes
1
answer
250
views
Cannot use SSH via internal IP address but can ping it easily
I have this setup in Oracle Cloud Infrastructure ...
I have two networks ..
Network 1:
internal cidr: 192.168.1.0/24
public IP: 10.0.0.1
Network 2:
internal cidr: 192.168.2.0/24
public IP: 10.0.0.2
...
- 101
0
votes
1
answer
797
views
Container - Id is shown as 2000
I installed Oracle Container using the image: oracleinanutshell/oracle-xe-11g:latest - on a Linux machine.
While doing, I copied one .sql file into /docker-entrypoint-initdb.d using "volumes"...
0
votes
1
answer
264
views
Boot broken on an Oracle VPS with msg "Gave up waiting for root file system device" & empty fstab
I'm using a free-tier Oracle VPS running Ubuntu and it seems like booting no longer works. I don't have physical access to the machine so I can't really try out solutions that ask for a reboot while ...
0
votes
1
answer
218
views
What determines UMASK for Oracle Job using UTL_FILE?
A PL/SQL job foobar622 writes files to UNIX/LINUX server using the following Oracle file I/O commands:
UTL_FILE.FILE_OPEN
UTL_FILE.PUT_LINE
UTL_FILE.FILE_CLOSE
In the past the files had these ...
- 393
0
votes
0
answers
1k
views
/etc/named.conf error with command systemctl status named.service
I am using Rocky Linux 8.7 on 64-bit
I am configuring and trying to start a BIND domain as follows:
[root@dbwr1 ~]# ls -l /var/named/localdomain.zone
-rw-r-----. 1 root named 506 May 14 19:29 /var/...
- 1
0
votes
0
answers
407
views
Oracle Linux 8.x - Performance Test (Stress / Load / IO / Network Usage / Memory Usage)
I want to do performance test on Oracle Linux 8 KVM guest server (It will be used as Application server (WLS 14c) and/or Oracle DB server).
What are the best tools I can provide this with? I saw an ...
- 11
1
vote
1
answer
195
views
Help with Folder permission problem with Oracle DB 7 and Solaris 7
I was wondering if anyone else has come across this issue with Solaris 7 and Oracle Database 7, I set the permissions of the folder as such chown -R oracle:dba /opt/oracle
but when trying to install ...
- 13
0
votes
2
answers
12k
views
How to write a shell script to run a sql query and send the query results in table format in email?
I need to run a SQL query using SHELL script in PUTTY and send the results in email body in table format with headers along with a message line on top.
I have written this so far but I am not able to ...
0
votes
1
answer
2k
views
Error in PREIN scriptlet in rpm package
I'm stuck with a problem when I try to install a local .rpm packages.
Error message:
Total size: 124 M
Installed size: 124 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
...
- 197
2
votes
1
answer
5k
views
Always Free: NO NETWORK after Upgrade from Ubuntu 20.04 LTS ARM to Ubuntu 22.04 LTS ARM
Scenario is the following:
I upgraded from Ubuntu 20.04 LTS to Ubuntu 22.04 LTS. However, after upgrading I lost total connection to the host and I'm only able to access it through Cloud Shell Console....
- 23
0
votes
1
answer
4k
views
Error installing oracle 19c database pre-install on oracle linux server 7.6
I'm tryin to install oracle 19c on oracle linux 7.6, I'm required to install oracle 19c preinstall , knowing that this is a fresh install I don't understand why i'm getting these errors :
yum -y ...
2
votes
1
answer
1k
views
How to start a bash script on Oracle Linux
What is the right way to start a bash script on Oracle Linux?
on a normal Linux server I use ./script.sh
But here is what I got when I do the same on Oracle Linux
[user@server ~]$ ./script.sh
bash: ./...
- 223
0
votes
0
answers
279
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:
- 1
2
votes
2
answers
2k
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....
- 23
0
votes
1
answer
224
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 ...
- 31
2
votes
1
answer
480
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 ...
- 121
0
votes
1
answer
215
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,...
- 23
1
vote
2
answers
3k
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 ...
- 21
3
votes
2
answers
4k
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 ...
- 33
1
vote
1
answer
165
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 ...
- 19
0
votes
1
answer
958
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 ...
- 413
1
vote
0
answers
70
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 ...
- 111
0
votes
1
answer
98
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
-1
votes
1
answer
123
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&...
- 1
0
votes
1
answer
4k
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 ...
- 101
0
votes
3
answers
5k
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 &...
- 87
0
votes
1
answer
139
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 )
...
- 243
1
vote
1
answer
234
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 ...
- 53
0
votes
1
answer
549
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
569
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
1
vote
1
answer
2k
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 ...
- 13
4
votes
3
answers
595
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
655
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/...
- 113
0
votes
1
answer
4k
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
306
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 ...
- 13
0
votes
0
answers
121
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 ...
- 101
1
vote
2
answers
4k
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 ...
- 31
2
votes
1
answer
532
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 = ...
- 23
1
vote
1
answer
7k
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 ...
- 336
1
vote
0
answers
71
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 ...
- 111
0
votes
1
answer
740
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 ...
- 1
0
votes
1
answer
534
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....
- 1