XE :: Installation Of Oracle Database 11g Express Edition On Ubuntu 12.10 LTS?

Mar 13, 2013

I am installed the Oracle database following the this link .

1.Downloaded 11g express edition

2.Created a new user 'oracle' under the group dba. Following steps are executed using this.

3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

4.Created /sbin/chkconfig file and added the entries as specified here

5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.

6.Below steps:

ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener

7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)

8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)

9.Set the following env variables in ~/.bashrc file

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

[code]....

Now when exectute any SQL statements on SQLplus, i end up with the following error

SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

I have increased the swap memory as specified in here

free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066

View 6 Replies


ADVERTISEMENT

Installation :: Oracle 12c On Ubuntu

Aug 27, 2013

Provide the installing steps of oracle 12c in ubuntu.

View 3 Replies View Related

Installation :: Oracle 11gr1 In Ubuntu 12.10

Feb 20, 2013

I am trying to install oracle 11gr1 to my ubuntu 12.10 and when i run ./runInstaller.sh

It said that OS Kernel Parameter: ip_local_port_range failed and the installer create a script to fix it but every time i run the script on terminal, it gives me

'The upper limit of ip_local_port range in response file is not greater than value in /etc/sysctl.conf, hence not changing it.
net.ipv4.ip_local_port_range = 9000 65535

View 11 Replies View Related

Installation :: Error Oracle 11g Ubuntu 12 Rdbms

May 7, 2013

I am installing oracle 11g under ubuntu 12.10(32bits) and getting an error 'all_no_orcl' 'ins.rdbms.mk'. It occurs when it tries to invoke the file.my laptop is 32 bits, 30.7 hd, 1.5 GB ram, 2MB cahe. The OS is installed on an external drive.

View 4 Replies View Related

Installation :: Install Oracle 11g Client In Ubuntu 12.04 64bit

Jul 3, 2013

Most of the ones I'm seeing online relate to the database, not the client.  I have linux.x64_11gR2_client.zip and and trying to do runInstaller and I get up to perform prerequisite tests and it tells me that I am missing packages and that kernel parameters are wrong. I've tried to run the runfixup.sh file and get a lot of this:

 ./orarun.sh: 186: [: true: unexpected operator./orarun.sh: 848: [: unexpected operator./orarun.sh: 864: [: unexpected operator./orarun.sh: 882: [: unexpected operator./orarun.sh: 903: [: unexpected operator./orarun.sh: 1052: [: unexpected operator./orarun.sh: 1057: [: unexpected operator./orarun.sh: 1075: [: unexpected operator./orarun.sh: 1085: [: unexpected operator./orarun.sh: 1115: [: unexpected operator./orarun.sh: 1143: [: unexpected operator./orarun.sh: 1189: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 1228: [: unexpected operator./orarun.sh: 1284: [: unexpected operator./orarun.sh: 1342: [: unexpected operator./orarun.sh: 1426: [: unexpected operator./orarun.sh: 1451: [: unexpected operator And many of the supposedly missing packages actually are installed. IE: make. I have make 3.81 installed but the installer insists upon make 3.80. 

View 3 Replies View Related

Oracle Installation Error On Ubuntu-sqlplus / Command Not Found

Mar 5, 2011

tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:

rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found

i have also tried to set the oracle_home, oracle path & oracle SID.

find the below configuration parameters which i have set to.

root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`

[code]....

View 4 Replies View Related

Way To Start Oracle Database 10g Express Edition On Fedora

Sep 29, 2007

am having problems starting Oracle Database 10g Express Edition on Fedora. Here is what I did in order to start it:

[root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start
[root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost +
access control disabled, clients can connect from any host

Not sure what I am doing wrong here.

View 2 Replies View Related

Installation :: Oracle Database Express And Other Editions Installation Doc Difference?

Mar 20, 2013

My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...

I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.

So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...

That is for express version only.

My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle

Mar 18, 2013

In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?

They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?

View 6 Replies View Related

Client Tools :: Toad On Ubuntu 8.04 Installation?

Feb 12, 2010

I want to install Toad on Ubuntu 8.04 . provide me link where step by step instruction guide is available

View 3 Replies View Related

A Sample Database For Ora 10g Express Edition

Nov 2, 2008

Just installed Ora 10g Express Edition. It has a sample database. But is there a rather larger database outside that I can download and import into Oracle for some learning reasons?

View 1 Replies View Related

Application Express :: Upgrade Within Oracle XE Database Installation On Windows 7

Aug 28, 2012

O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============

Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.

It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.

View 2 Replies View Related

Express Edition (XE) :: Oracle Express E 10g Or 11g RPM Package For Linux 32x

Oct 18, 2012

I would like to install Oracle Express Edition on Linux. I have some troubles on x64 architecture of Linux with win32 progs that runs via wine. And I need Oracle for developing. So, I would like install x32 Oracle Express Edition, but I can't find it anywhere. Is it exists.

Why is Oracle Express Edition 32x exist for windows, but there is not Oracle Express Edition 32x for Linux? We are using widely Oracle 10g. And there is many special difference with 11g. But there is no anywhere 10g version. Where can I download it (for Linux)?

View 2 Replies View Related

Express Edition (XE) :: Uninstalling Oracle XE?

Dec 10, 2012

I tried to uninstall Oracle XE 11g and i got 1402 error from Windows Error: [URL]...

what is happening. I can not uninstall or repair either.

View 5 Replies View Related

Enterprise Manager :: Oracle 9i Enterprise Edition Installation Error / End Header Not Found

Feb 18, 2011

My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:

Not a zip file(End header not found)

View 1 Replies View Related

Heterogeneous Connectivity :: Database Link Between Oracle11g Express Edition And MySQL using Odbc

Nov 8, 2012

I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.

View 1 Replies View Related

SQL & PL/SQL :: Horizontal Fragmentation In Oracle 10g Express Edition?

Feb 28, 2012

I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? list out the steps that should be performed. I saw the concept of link but really failed to understand that.

View 14 Replies View Related

Forms :: Oracle 10g Express Edition Can Support 6i

Mar 2, 2007

I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.

If there is any patch to connect forms 6i into oracle 10g express edition.

View 3 Replies View Related

Express Edition (XE) :: Oracle 11g R2 Doesn't Start?

Sep 3, 2013

I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output 
Starting Oracle Net Listener...Done
Configuring database...

Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

When I look at the logs I get the following error ORA-01034: ORACLE not available.  After receiving this error I have attempted to start Oracle manually.

sqlplus "/as sysdba"
 
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
 
As you can see I got

ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions 

/u01/app/oracle/product/11.2.0/xe/config/log# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/sda1                 46G  9.7G   34G  23% /
none                     4.0K     0  4.0K   0% /sys/fs/cgroup

[code]...

View 4 Replies View Related

Express Edition (XE) :: Not Connecting To Oracle Homepage?

Sep 28, 2012

i am using windows xp home edition (with oracle 11g r2). oracle installed with out any problems but when i click get started internet explorer it says(internet explorer cannot display the webpage) this is the address get started open up to [URL]...but does not work.

View 7 Replies View Related

Express Edition (XE) :: Unable To Install Oracle 9i

Oct 10, 2013

could i no longer install oracle 9i.2. should i install other version of oracle as 11g XE.  What possible steps should I take than Q.

View 8 Replies View Related

XE :: Use Oracle DB 11g Express Edition With Atomikos Transactions

Jul 16, 2012

I'm able to use Oracle 11g Standard/Enterprise Edition with Atomikos for XA transactions.(XADMS).

My question is Can I Use Oracle DB 11g Express Edition with Atomikos for XA Transactions.

View 4 Replies View Related

XE :: Oracle 10G Express Edition Account Locked

Aug 16, 2012

My Oracle 10G Expression Edition Account locked gets locked, where to raise the request to unlocking my account.as my user name:system

View 4 Replies View Related

11g Oracle Express Edition - Destination Host Unreachable?

Jan 11, 2013

I installed Oracle 11g Express edition in my local Machine(Windows 7).listener.ora, tnsnames.ora files seems fine. Service and listener are running; While trying to connect to the my db sqlplus>connect sys/oracle as sysdba

I am getting "ora - 12543 TNS: destination host unreachable."

what could be the issue. Find below listener.ora, sqlnet.ora, tnsnames.ora files:=

listener.ora file:=
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)

[code]....

View 1 Replies View Related

Is Full Text Search Possible In Oracle 10g Express Edition

Apr 29, 2011

Is full text search possible in oracle 10g express edition. If so, how is it possible. I browsed many places but couldn't find that.

View 1 Replies View Related

Globalization :: Non-English Character In Oracle 10g Express Edition

Oct 5, 2012

I have a table. It's name is INSTITUTION. It has a NUMBER INS_ID and NVARCHAR2(50) INS_NAME . INS_NAME can contain Turkish characters, such as "ğ,ü,ş,ç,ö". According to business logic, there can not be a repetition on the INS_NAME.User will enter institution name from a textbox in ASP.NET , and I check this name in database from c sharp code, if there is no repetition, we will add this record.

The problem is; when user enter a instition name that contains Turkish character, there is a duplication. If there is a instition name is *"su işleri"* , the both query; SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; and SELECT * FROM INSTITUTION WHERE INS_NAME = *'su isleri'*; returns no result, even though there it is.But if instition name is "oracle corporation" (there is no Turkish character) it query successfully. I have the same problem in Toad for Oracle 11.5.1.2. When I query database from toad SELECT * FROM INSTITUTION, the phrase *"su işleri"* has appeared. But when I query SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; , there is again no result.When I connect oracle database directly and perform the query SELECT * FROM INSTITUTION , the phrase *"su isleri"* (not *"su işleri"* ) has appeared.

Here are the language settings of the database:

National Language Support
National Language Parameter Value
NLS_CALENDAR______________GREGORIAN
NLS_CHARACTERSET__________WE8MSWIN1252
NLS_COMP__________________BINARY
NLS_CURRENCY______________TL
NLS_DATE_FORMAT__________DD/MM/RRRR
NLS_DATE_LANGUAGE________TURKISH
NLS_DUAL_CURRENCY_________YTL
[code]....

View 8 Replies View Related

Express Edition (XE) :: Oracle Doesn't Start Correctly With 3G Router

Oct 7, 2013

I have used a HUAWEI dongle directly connected to my PC. First, the operating system and Oracle start up, then I connect to the internet using the Huawei Mobile Partner utility. Any application can connect to Oracle and use it correctly. All OK. Now I have added a 3G router which is connected to the PC by ethernet cable and has the Huawei dongle connected to a USB port on the router. All works correctly if I follow the sequence: 

1) Start the PC with the router switched off, and wait until Oracle has fully started. 

2) Power the router up and wait 2 minutes until Windows says the 100 Mb ethernet link is open. Oracle.exe in Task Manager is about 210 Mb, and sometimes more, depending on activity. 

However, if I switch on the router first and then start the PC, Oracle does not start correctly. It rejects connection requests forever more, indicating Network Adapter could not establish the connection: Code 17002.In Task Manager Oracle.exe occupies only 145Mb. What can I do to get it to start correctly ? I can dig into Listener.ORA, TNSNAMES.ORA and HOSTS without any problems, and have often modified them manually (not the case here), but logs and traces escape me !

View 3 Replies View Related

Oracle 11g Express Edition - Load Huge Data Into Table

Nov 6, 2012

I am using oracle 11g Express Edition, I have a file of .csv forma, Which has a data of size 500MB which needs to be uploaded into oracle table.

Which would be the best method to upload the data into table. Data is employee ticket history which is of huge data.

How to do the mass upload of data into oracle table.

View 3 Replies View Related

Express Edition (XE) :: Oracle 11g On Linux Mint - MEMORY_TARGET Not Supported On This System

Feb 5, 2013

I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :

cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "$1" in
start)

[code]...

I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsAnd this is the content of the file postDBCreation.log :
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

[code]...

View 3 Replies View Related

Error During Installation Of 10g Personal Edition?

Sep 15, 2010

I am trying to install Oracle 10g on my personal laptop. I have a Windows 7 system, with MS Virtual PC and XP mode. When trying to install 10g Personal Edition, I encounter the following error:

java.util.zip.ZipException: invalid stored block lengths
at java.util.zip.InflaterInputStream.read(Unknown Source)
at java.util.zip.ZipInputStream.read(Unknown Source)
at java.io.FilterInputStream.read(Unknown Source)
at oracle.sysman.oii.oiix.OiixFileOps.copyStream(OiixFileOps.java:1421)

[code]...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved