Installation :: Oracle Database 11g Release 11.2.0.3.0 IBM AIX On POWER Systems (64-bit)

Mar 13, 2013

Is Oracle Database 11g Release 2 (11.2.0.3.0) available for IBM AIX on POWER Systems (64-bit), Or do we need to upgrade 11.2.0.1 to 11.2.0.3.0.

View 4 Replies


ADVERTISEMENT

Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone

May 11, 2013

which is really a HA zone clustered in VCS(not important for installation of the database).

What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.

View 3 Replies View Related

Windows :: Unable To Continue Oracle 11g Release 2 Installation

Jul 24, 2013

I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.

The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.

View 2 Replies View Related

Server Administration :: Oracle Database Crash After Electric Power Down?

Feb 1, 2011

My oracle DATABASE (on archivelog mode ) crash after electic power down.when try to restart the database ( startup "sid") I got error :

SQL> startup
Oracle instance started
Instance ORACLE lancée.
Total System Global Area 1536602112 bytes
Fixed Size 2211288 bytes
Variable Size 1191182888 bytes

[code]....

There are no alerte log file.

View 4 Replies View Related

Installation :: Space To Install 11.2.0.3.4 On AIX Power System (64bit)

Jan 17, 2013

we have installed oracle database 11.2.0.3.0 using 12G for grid and 8G for DB. And now we want to apply the PSU 11.2.0.3.4, but found that there is not enough.

How much we need to upgrade to 11.2.0.3.4 totally?

View 5 Replies View Related

Downgrade Oracle Database 10g Release 10.2.0.2.0 To 10.2.0.1.0?

Nov 29, 2011

am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.

i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to

>take full backup of oracle DB
>ORACLE_HOME/bin/emctl stop dbconsole
SQL> STARTUP DOWNGRADE
DROP USER sysman CASCADE;
>SQL> SPOOL downgrade.log

[code]....

View 1 Replies View Related

Security :: How To Mask Data In Oracle 11g Database Release 1

Oct 16, 2012

how to mask data in oracle 11g database release 1

my environment is
Database: 11g release 1
os: AIX 6 (64 bit)
GC:10g release 1

View 12 Replies View Related

RAC & Failsafe :: 11G Release 2 Grid And RAC Installation On Solaris 10

Nov 24, 2010

Share 11g Release 2 Grid infrastructure and RAC installation experience on Sun SPARC. Any documentation which provide complete information from server setup to database setup.

View 2 Replies View Related

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

Dec 27, 2012

how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.

View 1 Replies View Related

RAC/ASM Clusterware Installation :: 11g Release 2 Install Missing Packages?

Aug 8, 2012

I'm trying to install 11g Release 2 on a CentOS (4.9) box, but the pre-req check shows that I'm missing the following packages (I had 9 to begin):

gcc-3.4.6 (X86_64)
gcc-c++-3.4.6(X86_64)
libstdc++-devel-3.4.6

Tried to use the yum command "yum install gcc" but get the following error.
Error: cannot find a valid baseurl for repo:update

I think this is due to the "CentOS-Base.repo" file, which I've tried to update by changing the mirror URL's but no success.Then tried to find the rpms online ([URL]...

INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: rm -f ntcontab.*

[code]....

View 2 Replies View Related

Replication :: Create Same Database Replica In 25 Systems?

Jan 2, 2010

I need to create same database replica in 25 systems. Which method can i use for that...each servers will hold exactly same data and structures

View 1 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

Installation :: Oracle 11G Database For 64 Bit Windows Installation Error

May 6, 2013

I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).

View 10 Replies View Related

Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases

Mar 5, 2013

what type of storage systems used for saving archive files and backup files "especially for oracle databases"

View 5 Replies View Related

How And When The Database Release A Row Lock

May 30, 2013

We are using the following statement to obtain a row lock in a table in the database(ORACLE 10G), SELECT * FROM {TABLE_NAME} WHERE ID = 1 for update and if we succeed grabbing the row lock we will continue to issue a update statement every 30 seconds to preserve the lock as far as possible. here is the update statement to preserve the lock,

UPDATE {TABLE_NAME} SET time = ? WHERE ID = 1.

As you see more longer we keep holding the row lock , more update statements are submitted in the pending transaction. In normal case our application can grab the exclusive row lock and works for a long time,however sometimes a connection reset exception is thrown and our application will close the connection(I assume the pending transaction will be rolled back by the database) and exit the JVM. Since other applications will keep trying to grab the same row lock to become the master role, we expect one of them can succeed but they are all failed because the database has not released the row lock as expected. how and when the row lock can get released in our use case?

View 14 Replies View Related

Security :: Authentication For Connected User Database Links (release 11.x)

Jun 16, 2013

I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,create public database link using 'orcl';then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.

View 4 Replies View Related

Installation :: Oracle Database 10g For AIX

Jan 2, 2013

Give me a link where i can download Oracle Database 10g for AIX?

View 4 Replies View Related

Forms :: Find Key Pressed And Release Action On Oracle 10g

Dec 14, 2012

we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.

As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.

Is it possible, as user release the key scrolling will stopped at same time ?

View 3 Replies View Related

Windows :: Installation Of Oracle Database 10g Or More

Nov 15, 2010

I want to install any version of Oracle database in my laptop IBM Lenovo Y450 64 bit, but i have win 7 home, how to install it in win 7 home edition, one main thing i don't have money to upgrade it to windows 7 ultimate,

View 3 Replies View Related

Replication :: To Upgrade All Oracle 10g Master Sites / Databases To 11g Release

May 28, 2009

I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.

View 1 Replies View Related

Reports & Discoverer :: Reporting Against Ap Invoice Hold Release Name In Oracle 11.5.10

May 9, 2012

why we seem to be unable to report against the ap invoice hold release date using Discoverer in Oracle 11.5.10? the person who wrote our current report used a decode statement to look at the last update date of the release lookup code to create a release date, but i am trying to recreate this in a different tool (Qlikview) and just wanted to understand why we seem to be unable to report on the field as is!

View 4 Replies View Related

Oracle 11g Installation - Database Instance Recovery

Oct 16, 2010

My database is working on Oracle 10g. After installing a Oracle 11g in my PC instance went down and my database got corrupt. What are the steps I should follow to recover my Database?

View 2 Replies View Related

Installation :: Oracle Database Client (32-bit) For Windows 7

Oct 25, 2012

where to download - Oracle database client(32-bit) 11.2.0.3 for windows 7 ?

View 5 Replies View Related

Data Guard :: Installation In Oracle 10g Database?

Sep 14, 2010

I am planning to use Data Guard facility in Oracle 10g database.

1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)

View 1 Replies View Related

Installation :: Two Versions Of Oracle Database On Same Server

Jul 31, 2012

Can i have 2 versions of oracle database installed on same server under one user on AIX also on windows,

Currently we have oracle 10.2.0.4.0 installed on AIX server, can we install oracle 11gR2 on the same server under on user, & both the versions will be in use.

How to manage the profile of the user having 2 oracle versions on AIX & on windows how to handle it.

View 2 Replies View Related

Server Administration :: Installed Database Oracle With Installation

Nov 17, 2011

Yesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup

export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted

select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also

export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba

database mounted

select instance_name from V$parameter;

and it shows instance name as green..i tried to see the datafile location for green database

select file_name from dba_data_files; it shows the orcl datafile locations.

View 6 Replies View Related

Installation :: Database 11g In Oracle Server Gives Display Error

Nov 5, 2012

I have downloaded and install oracle server6 and followed the

[URL].......

but i am getting error as follows

./runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 42983 MB Passed
Checking swap space: must be greater than 150 MB. Actual 7951 MB Passed
Checking monitor: must be configured to display at least 256 colors
Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation, Continue? (y/n) [n] n

User Selected: No

I have tried
#export DISPLAY=localhost:0.0
#export DISPLAY=localhost:0.0
xhost: unable to open display "localhost:0.0"

View 2 Replies View Related

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 View Related

Installation :: Unable To Install Oracle Database Client On Linux?

Jan 4, 2013

I have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.

, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.

Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.

View 22 Replies View Related

RAC/ASM Clusterware Installation :: OLR Integrity Error During Oracle Database Install

Sep 12, 2012

OS=Redhat 5
Oracle=11gr2
Grid=11gR2

I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check

OLR Integrity - This test checks the integrity of OLR on the local node.
Expected Value : n/a
Actual Value : n/a
List of errors:
- Permissons of file
"/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"]
- Cause: Cause of Problem Not Available
- Action: User Action Not Available.

View 1 Replies View Related







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