Questions tagged [oracle]
The oracle tag has no usage guidance.
47
questions
0
votes
0answers
24 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
74 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
42 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
1k 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
33 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
125 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
65 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 ...
0
votes
0answers
26 views
Oracle VirtualBox can't boot Oracle ODI VM
I'm facing a strange issue. I've downloaded VM from Oracle for Oracle Data Integrator (https://www.oracle.com/technetwork/middleware/data-integrator/odi-demo-2032565.html), and it works like a charm ...
1
vote
0answers
25 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
643 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
66 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
58 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
2k 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
0answers
248 views
Fatal Error DISPLAY variable set incorrectly: :0
I want to install oracle weblogic server. I already downloaded it and it's fmw_12.1.3.0.0_wls.jar. In order to install it I'm instructed to run java -jar fmw_12.1.3.0.0_wls.jar. But when I run it I ...
0
votes
0answers
226 views
Linux UDEV not reload configuration automatically after system reboot
I have a problem with my single host, where I'm using Oracle ASM on raw disks (UDEV).
In file /etc/udev/rules.d/30-oracle_asm.rules I defined UDEV rules
KERNEL=="sd?", PROGRAM=="/root/SCRIPTS/asm....
0
votes
1answer
255 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
310 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
169 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
241 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
232 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
932 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
193 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
375 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
483 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
295 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
18 views
VBoxGuestAdditions Error 112
How to fix this error that occurs while trying to install VBoxGuestAdditions?
0
votes
1answer
1k 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
442 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
672 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
73 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
488 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 ...
1
vote
0answers
491 views
display unix variable with dbms_output.put_line
I have a loop with while that is reading a file and then makes a query of these values.
But when I'm trying to show a message with dbms_output.put_line it says :
dbms_output.put_line(henry);
...
0
votes
0answers
217 views
How do you install Oracle on Linux when you get the error “ORA-27101: shared memory realm does not exist”?
I am installing Oracle 11 on CentOS 7.2. I have installed it before on servers with less RAM.
I get this error:
ORA-01034: ORACLE not available ORA-27101: shared memory realm does
not exist
...
2
votes
1answer
373 views
Install Oracle Java from a mirror in terminal
I can't access Oracle servers for some reason. Is there any way to install Java from a mirror?
I'm using Fedora 24 and I need to install Oracle Java on it.
1
vote
1answer
765 views
Install Oracle Java 8
I'm trying to install Java 8 on a GitLab Runner like this:
apt-get --quiet update --yes
apt-get --quiet upgrade --yes
apt-get --quiet install --yes software-properties-common python-software-...
0
votes
1answer
186 views
parsing oswiostat
I am looking for a way to parse an iostat file and grab the time and iowait. My files look like this:
Linux OSWbb v7.3.3
zzz ***Wed Jul 20 19:00:08 EDT 2016
avg-cpu: %user %nice %system %iowait %...
0
votes
3answers
865 views
What is Solaris IPS / How does it work?
I have read the docs and PDF's from Oracle on the matter but they were too broad and too much analytic for me to understand.
Could someone provide me an overview (as he/she understands it) of the ...
0
votes
1answer
639 views
How to extract db version from oratab
I have a requirement to extract the database version in order to fulfill a script requirement.
I need to fetch the db details from oratab and its version.
Suppose my entry in oratab as below :
...
1
vote
2answers
2k views
JDK 1.4.2 - where can I download the source?
I want to install Java JRE 1.4.2 or JDK 1.4.2 on a recent Amazon Linux server. The best option so far seems to install from source. However - where can I download this? I believe 1.4 is still from the ...
0
votes
1answer
520 views
Oracle XE silent config ignores response file…?
I'm trying to configure Oracle XE 11.2 (on Oracle Enterprise Linux 6.6) in "silent mode" via a response file. I'm using the response file provided in the package (Disk1/response/xe.rsp), replacing ...
1
vote
2answers
865 views
ssh tunnel and oracle
On oracle server i can connect clear
sqlplus user/pass@hostremote/SID
If i make a tunnel
ssh -L 1521:localhost:1521 -F -n hostremote -vvv
give me
debug1: Connection to port 1521 forwarding to ...
