The oracle-database tag has no usage guidance.
0
votes
1answer
47 views
Shell Script: Login to Oracle DB and fetch data to variable
I have this shell script, which login to oracle database, select from a table and put the result on other variable
Username=User1
Password=Pass1
eval DatabaseName=db_tst
var1 = 1
Result=`sqlplus -...
1
vote
1answer
29 views
What network settings need to be changed in order to access my guest oracle linux pre-built VM from my host?
I just downloaded and successfully installed this oracle linux/database pre-built virtual machine.
I was successfully able to login as oracle/oracle user and view the desktop with the red-colored ...
-1
votes
1answer
25 views
Pick Values From A Oracle Select Query
I have executed the below command (Part of a 2 step procedure required for password reset when we face the error ORA-28007).
SQL> select USER#,NAME,PASSWORD FROM user$ where name='TESTUSER';
...
0
votes
0answers
105 views
ORA-12560: TNS: protocol adapter error
I have tried to install Oracle 11g R2 on Solaris 10 in Virtual Box. While installing it get completed 95% but while it try to install "Database Configuration Assistant" it shows "ORA-12560: TNS: ...
0
votes
0answers
286 views
How to Install Oracle 12 on Debian Jessie server?
I want to install Oracle version 12 on a server Debian Jessie, but I can't find any tutorial or commands to follow.
How can I install it?
0
votes
0answers
198 views
Shell script to check the ASM diskgroup space in Oracle and send a mail
I am trying to write a shell script to monitor ASM instance in Oracle and mail the respective people in mail list. I have written the following script.
#/bin/sh
#set -x
USER=xxx
PASS=yyy
...
0
votes
1answer
968 views
how to set static ip for guest OS on VirtualBox [duplicate]
My host is Ubuntu 12.04 and I have installed Virtual Box on it. Network setting of Virtual Box is NAT.
Then I have Oracle Enterprise Linux as guest.
Now I want to set a static IP for my guest, ...
1
vote
1answer
992 views
What is the best way to install Oracle 11g R2 and SQL Developer on CentOS 7 / RHEL 7?
I read this article suggesting use of Oracle's yum repository in conjunction with CentOS 6.x.
I also read this other article, which seems to suggest manually downloading zip files and taking many ...
0
votes
1answer
353 views
Finding the Oracle JDBC version using the command line
I want to check out the Version of my Oracle JDBC driver.
In this case, I know the driver is 12.1.0.2:
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
But without that I am searching for a ...
1
vote
2answers
1k views
how to uninstall oracle 11g xe from centos 7?
I installed oracle 11g xe to test a software and have not been using it for a while. How to cleanly uninstall?
0
votes
1answer
4k views
xhost + is not working with Oracle installation
I am trying to install Oracle on Ubuntu 14.04. I have followed instructions and now I am trying to start the installation. However, I am facing problems.
If I run ./runInstaller command with oracle ...
0
votes
1answer
105 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 ...
0
votes
0answers
492 views
Doctrine OCI8 charset behavior between php-cli and php-fpm
My Oracle database is in ISO8859-1 (not by choice).
I'm struggling with segfault from php-fpm for a couple of days now. To dig out the source of it I've set two parallel environnements with the ...
0
votes
2answers
35 views
Assigning output of a Dynamic Performance View (v$asm_diskgroup) to a variable in Shell Script
I am trying to assign the output of
select name from v$asm_diskgroup;
to a variable in Shell . The script is failing because of special character '$' in the table name .
Note : While i tried ...
3
votes
2answers
626 views
How to install oracle11gr2 on ubuntu 15.04?
I am working with this tutorial.
But i got this error on step 5:
Package libtiff4 is not available, but is referred to by another package.
This may mean that the package is missing, has been ...
2
votes
1answer
222 views
SQLplus and Oracle, bad UTF-8 display
I have set
export NLS_LANG=Italian_ITALY.UTF8
db is on UTF-8
SELECT * FROM NLS_DATABASE_PARAMETERS
NLS_CHARACTERSET |AL32UTF8
But sqlplus ...
0
votes
1answer
927 views
Find out home directory of running Oracle instance
There are two oracle directories on our system:
oracle
oraclex
How can I find out which of them is used by the running Oracle instance?
0
votes
0answers
133 views
Edit Oracle Path on Ubuntu Virtual Machine
I have two virtual machines ubuntu 14.04 LTS, one is a server when I installed oracle 11g express, and the other is a simple client. My goal is to run an sql query remotely from the client machine. So ...
-1
votes
1answer
13k views
Sqlplus: Command not found
I have two virtual machines ubuntu, one is a server when I installed oracle 11g express, and the other is a simple client.
My goal is to run an sql query remotely from the client machine.
So I ...
2
votes
1answer
2k views
Error When trying to install a package using dpkg
I am trying to install Oracle SQL Developer onto a Debian Linux server.
I started off by downloading a package from the Oracle website;
sqldeveloper-4.0.3.16.84-1.noarch.rpm
I then called the ...
1
vote
1answer
116 views
VirtualBox Time Sync
I use Oracle Virtualbox 4.2.18 as a guest Linux environment on my Mac OSX, so I can use it to host an Oracle DB (11G R2).
The problem I have is that every day at various points the system time of the ...
1
vote
1answer
203 views
Oracle sqlplus like psql output
Is possible to get oracle sqlplus output like psql?
On psql i have perfectly ordered
video=# select * from generale where titolo ~* 'brivido';
idtitolo | titolo | anno | genere | durata | ...
0
votes
1answer
501 views
How to install and run oracle 12c in oracle linux 6.5?
I was trying to install oracle linux 6.5 from this link. I downloaded the OracleLinux-R6-U5-Server-x86_64-dvd . Now while installing I didn't get any GUI as the link said I would get after test/skip ...
3
votes
2answers
19k views
“[unixODBC][Driver Manager]Data source name not found, and no default driver specified” when connecting to OracleDB using ODBC
I am trying to make an odbc connection to an oracle db from linux. When I login as root, it works. My root profile is as below:
more ~/.profile
export ODBCINI=/etc/unixODBC/odbc.ini
export ODBCSYSINI=...
0
votes
1answer
1k views
Benefits of hyperthreading for an Oracle database
I'm running Oracle 10 on a blade450 g6. I have hyper-threading turned on but I have heard several people say that Oracle databases don't play well with it. Are there specific performance or ...
1
vote
1answer
356 views
Oracle Weblogic IPv6 with Oracle database on IPv4
I have one weblogic application currently working on IPv4 and jdbc connection to database is on IPv4.
Since my machine has an additional Ethernet port that supports IPv6, I am thinking to add an ...
2
votes
0answers
63 views
Confusing my IP stack
At work, I have an Oracle GRID/RAC cluster of two hosts, including Oracle's SCAN functionality. Picking one host: eth0 is the management port on 169.254.10.25. eth1, eth2, and eth3 comprise bondeth0 (...
3
votes
1answer
1k views
Cannot install BIND dns with yum on Oracle Enterprise Linux 6.1
I am currently using Oracle Enterprise Linux 6.1 to use for Oracle RAC. However I am stuck at installing BIND (DNS Server) at the VM I've set up.
I've used the following command:
yum install ...
5
votes
5answers
33k views
installing Oracle 11g r2 on linux 6.1
I am trying To Install the Oracle 11g r2 on Linux 6.1 but i am Not Successful since a couple of days.When I have done all prerequisites for oracle 11 g .But When I run The Installer I got this Error
...
0
votes
2answers
9k views
Oracle: ORA-01089: immediate shutdown in progress - no operations are permitted
I have Oracle XE 10.0.2 installed on my development system.
Recently I have been unable to restart it:
$ sudo /etc/init.d/oracle-xe stop
Shutting down Oracle Database 10g Express Edition Instance.
...
-2
votes
1answer
590 views
RHEL6: Failed Dependencies when installing a package
Hi I'm getting errors when forcing to install unixODBC package on RHEL 6 here is the following error: http://flic.kr/p/jBEFvP
I don't know where to get the following packages that were needed by the ...
4
votes
2answers
7k views
Insert to Oracle table in a loop
Requirement: In one server in a directory multiple files are present. I need to read the file names and populate into a Oracle table.
I have written the script like this, but its not working:
#!/bin/...
1
vote
1answer
259 views
rpmbuild library register for 'requires'
Big Picture:
I am building an in-house rpm for a customized php. I build an rpm which works, but generate library requirements that I can't seem to meet without using 'nodeps', which I want to avoid ...
1
vote
2answers
10k views
Oracle ASM disk group list
We have Oracle ASM running under LVM and now I want to expand one of ASM disk group size, but I don't know which LVM filesystem is associated with specific ASM disk group. Is there a way to find out ...
2
votes
1answer
7k views
Process Monitoring on Solaris
$ prstat -t
NPROC USERNAME SWAP RSS MEMORY TIME CPU
164 oracle 5446M 5445M 8.3% 13:47:50 1.6%
52 root 576M 728M 1.1% 42:29:50 1.0%
1 noaccess 300M 273M 0.4% 0:20:54 0.0%
...
2
votes
0answers
5k views
Error building Oracle client 11g R2 on RHEL 5.5
We are trying to install oracle 11g R2 64 bit in Rhel 5.5 machine ( 64 bit ). Kernel version is 2.6.18-194.el5. We are getting the below error while installation.
error in invoking target 'mkldflags ...
4
votes
2answers
22k views
Shell Script - syntax error near unexpected token `else'
With the following shell script, why I am getting errors
syntax error near unexpected token `else'
Shell Script
echo "please enter username"
read user_name
echo "please enter password"
read -s ...
1
vote
1answer
2k views
Error not a valid identifierd when executing shell script [duplicate]
I have the following shell script in order to connect to database and do some tasks.
echo Please enter userid:
read USER_NAME
echo "Please enter password:"
read -s PASS
SID=${ORACLE_SID}
if [ "$...
1
vote
2answers
7k views
Can not start Oracle after installation
I'm using Lenovo G580 under intel i5 third generation with 4GB RAM. I'm trying to install Oracle 11g standard edition
After completing all pre installation and post installation procedures, when I ...
3
votes
2answers
6k views
How to Install Oracle 11gR2 on Ubuntu Server 13.04
I want to install Oracle 11gR2 for Linux on Ubuntu Server 13.04.
I have downloaded Oracle 11gR2 for Linux, and when I execute use runinstaller it require GUI supported files.
While Google I got ...
1
vote
1answer
81 views
Oracle 11gR2 grid silent installation: error for privateinterconnects
I am installing Oracle grid 11gR2 using silent install with response file. I am getting error after "Collecting interface information for node 1" in logs.
I have a feeling that this could be due to ...
2
votes
1answer
10k views
How to remove Oracle Wallet using orapki?
Hi i'm on Centos using oracle 11g
And i've created a wallet using :
$ orapki wallet create -wallet /u01/app/oracle/admin/DB11G/wallet -pwd WalletPasswd123 -auto_login
Now i want to remove it to try ...
1
vote
0answers
696 views
System packages not detected by the Oracle installer
I am installing Oracle 11g 32bit on Ubuntu Linux and the setup shows the following error message on Prerequisite Checks screen:
This is a prerequisite condition to test whether the package "make-3.80"...
1
vote
1answer
7k views
Automatic Startup of Oracle 11gR2 on CentOS 6.3
I've setup a handful of CentOS 5.6 servers with Oracle 11gR2 and not run into this particular problem, but I have hit a wall with CentOS 6.3 and auto-starting Oracle. Not sure if this is related to ...
1
vote
2answers
1k views
How to check how many Oracle user sessions are running
I need to check how many users are connected to server for specific applications through a browser. I'm mainly interested in Oracle. My server runs RHEL.
1
vote
1answer
164 views
High-latency VM-centric workstation, vs. low-latency, (but, hack-ish) configuration for Oracle 11g
tl;dr Low-latency native (i.e. VM-less) development workstation vs. higher latency VM-centric workstation?
Hey StackExchange, I'm unsure of whether or not I should be using a VM for development, as ...
2
votes
1answer
2k views
Why is connecting to Oracle Express 11 is very slow on Fedora 17?
I installed oracle-xe-11.2.0-1.0.x86_64.rpm on Fedora 17-64-bit. I was wondering why it is very slow, for example when I want to connect to it using Oracle SQL Developer or JDBC in my web application.
...
1
vote
0answers
155 views
Installing rpm & dependencies
I am trying to install an rpm, namely the Oracle 10g database for CentOS 6 for testing an app.
The problem is that the machine the OS is installed on does not have access to the internet and there ...
3
votes
1answer
2k views
AIX 6.1 JFS2 Oracle files system, not using much files system cache
I am running Oracle database on AIX 6.1, Oracle using JFS2 file systems. Maxperm is set to 90%. This is busy database server, but it is not using the file system cache (less then 2%). The system has ...
4
votes
1answer
4k views
How to install Oracle on Arch Linux?
I tried going through the wiki
I was able to complete until here.
wget --http-user "I accept www.opensource.org/licenses/cpl" --http-password "." http://www.research.att.com/~gsf/download/tgz/INIT....
