The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
10 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
14 views

Oracle 11g installation - unable to open display error (red hat 7)

I'm installing Oracle 11.2 client in a Red Hat 7 machine but I'm stucked in this step: xhost fully_qualified_remote_host_name The error that appears is the following: unable to open display ":0.0" ...
0
votes
0answers
36 views

how to Install oracle 12 on Debian jessie server

I want to install Oracle version12 on a server Debian Jessie but I can't find any tutorial or the commands to follow. How can I install it?
0
votes
0answers
33 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
65 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, ...
0
votes
1answer
116 views

Best practice for installing Oracle 11g R2 on CentOS 7 / RHEL 7

I am a new user. I tried to log into chat to ask advice in framing this question, but I need at least 20 reputation points to participate in chat, so I am asking here with the intent of improving my ...
0
votes
1answer
34 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 ...
0
votes
2answers
48 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
250 views

Failed to open the bootstrap file in MySQL

After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
0
votes
1answer
441 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
27 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
265 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
24 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 ...
3
votes
2answers
448 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 ...
1
vote
0answers
138 views

SQLplus and oracle,bad utf8 display

I have set export NLS_LANG=Italian_ITALY.UTF8 db is on utf8 SELECT * FROM NLS_DATABASE_PARAMETERS NLS_CHARACTERSET |AL32UTF8 But ...
0
votes
1answer
448 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
81 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 ...
-2
votes
1answer
5k 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
1k 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 ...
0
votes
0answers
90 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
151 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
422 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
14k 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 ...
0
votes
1answer
981 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 ...
0
votes
1answer
249 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 support 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
28k 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 ...
1
vote
2answers
6k 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
411 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 ...
1
vote
1answer
178 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
7k 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
6k 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
4k 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
14k 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
1k 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
5k 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
65 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 ...
0
votes
1answer
7k 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 ...
1
vote
0answers
618 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 ...
1
vote
1answer
6k 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
162 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
1k 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
140 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
1k 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
3k 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 "." ...
0
votes
0answers
521 views

How to backup and restore Oracle 10G Express in Linux VPS?

I have installed Oracle 10g Express in two Centos VPS server. How can I generate an Oracle backup from server one, so that I can restore the database on server two? Can anyone help on this?
6
votes
1answer
8k views

Where to get 32-bit Oracle-XE 11g binaries?

Oracle website offers 64-bit RPMs for its 11g versions. Do they offer 32-bit somewhere or does someone else do? Are there Debian binaries available?