Questions tagged [oracle]
The oracle tag has no usage guidance.
60
questions
0
votes
0answers
12 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
68 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
0answers
8 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 )
...
0
votes
0answers
24 views
How to create a oracle wallet with chain certificates?
I have three certificates, root, intermediate and server. Intermediate certificate is signed by root certificate and server certificate is signed by intermediate certificate.
What are the steps to ...
1
vote
1answer
40 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
38 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
18 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
65 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 ...
0
votes
0answers
13 views
Configure huge pages for Oracle RAC installation
I am going to install an Oracle RAC 18c environment over rhel 7.5 and I do not fully understand how I should configure the huge pages section ... specifically what values to put in nr_hugepages and if ...
1
vote
2answers
75 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
41 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
0answers
6 views
When cloning from an OEL7 template VM in VMware, how do you change any unique identifying info that may be redundant on all clones?
I know there is UUID and other info that is used for disk partitions and network. I am most concerned that I would have issues somewhere by all machines in an environment that were built using the ...
0
votes
1answer
673 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
184 views
Pacemaker RHEL 7 - Oracle Listener stopped on Failover
We have two node cluster using a shared storage (HA-LVM) for Oracle Database. And i created following resources
stgdbfence1 (stonith:fence_vmware_soap): Started RTG-STGDB-01.gulfpc.com
...
0
votes
0answers
23 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
26 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 ...
0
votes
0answers
77 views
Missing steps to run OMSPatcher?
I'm having some trouble applying an Oracle patch to the Management Services. After downloading and unzipping the particular patch in ORACLE_HOME, I get an error that I don't understand when trying to ...
1
vote
2answers
421 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
54 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
votes
1answer
3k 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
38 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
242 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
129 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
4k 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
40 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
690 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
113 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
86 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
3k 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
342 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
385 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
251 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
298 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
307 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
1k 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
261 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
444 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
1answer
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
2answers
576 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....
0
votes
1answer
322 views
Clear OS-level cache
I have Red Hat Enterprise Linux 6 with Oracle 12c database. I am doing performance benchmarking but there seems to be an OS level cache causing only 1st time read to take significant time.
How can I ...
0
votes
1answer
19 views
VBoxGuestAdditions Error 112
How to fix this error that occurs while trying to install VBoxGuestAdditions?
0
votes
1answer
2k views
How to insert null for missing column? [closed]
I want to write a script that inserts values into a list of tables as follows.
Example:
insert into TABLE1
( a,b,c)
select a,b,c from TABLE2;
But TABLE2 does not have column C, so I want to insert ...
2
votes
1answer
554 views
How to make a script “wait” for an operation to finish?
I have two scripts, or maybe better call one a wrapper for the another.
Here comes the wrapper:
#!/usr/bin/expect
set timeout 20
spawn "./installOracleDatabase.sh"
expect "replace Disk1/upgrade/...
0
votes
1answer
776 views
Problem running a web server in Oracle VM Virtualbox with Port Forwarding
I am using Oracle VM VirtualBox and running a CentOS 7 instance on it.
I have setup two network adapters for this machine. One is set in Host Only mode and the other one is in NAT mode.
I am able to ...
1
vote
0answers
27 views
How to make an SQL statement display how many rows it has counted so far?
Suppose there is a table with billion rows, and I issue a select statement as below,
SQL> select * from big_table;
During the statement execution is it possible to print the number the rows it ...
0
votes
1answer
2k views
bash: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory
When I open my terminal, I see this on top of the terminal.
I removed Oracle XE. However, I cannot remove this line from my terminal.
Also I cannot remove Oracle user from my group. What can I do?
...
1
vote
2answers
77 views
Select the contents respective to some specific content from a file and move it to an output file
I have a file tnsnames.ora and its contents are as below.
NEWDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linuxerp.de.mph.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ...
0
votes
1answer
2k views
Problem running rman in cron
I have a problem with script scheduled in cron. In cron I have following line:
33 09 * * 1-5 oracle /data1/backup/scripts-test/rman.sh > /data1/backup/log.txt 2> /data1/backup/log_err.txt
As ...
3
votes
1answer
1k views
su cannot open session error when starting Oracle XE database
I have a RHEL 7.2 server with Oracle 11g Express Edition (11.2.0) installed. The installation of Oracle created a file named "oracle-xe" in /etc/init.d This is a bash script that can be used to ...
0
votes
1answer
539 views
how to find the logged in user in linux running oracle session
i like to find out the logged in user to linux and running some session . we cannot use the os_user option as we all use sudo user before login to oracle. so how to find out the super user who logged ...
