Oracle 11g R2 Installation Steps For Aix 6.1
Oct 3, 2012The steps for the subject line mentioned. and pre-reqs or post-checks if any.
View 3 Replies
ADVERTISEMENT
Server Administration :: Oracle 11g Patch Installation Steps
Jan 16, 2011I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.
View 4 Replies View RelatedServer Administration :: Installation Steps For Oracle 10g 10.2 On Linux 6 Using Vmware
Mar 16, 2012A link which describe step by step with screen shots how can i install oracle 10 r2 on oracle linux server release 6.1 using vmware workshop 8.my actual os is windows server 64 bit in this in install vmware 8 and i install oracle linux server release 6.1 32 bit now i want to install oracle 10g r2 or oracle 11g r2 on this .
View 2 Replies View RelatedRAC/ASM Clusterware Installation :: Verification Of Steps To Convert Single Node To RAC
Jan 16, 2013I have a single node Oracle E-Biz 12.1.3 Installation.We plan to convert this to a dual node RAC install and I wanted to run by the steps to perform this AND clone over the current production system to the new RAC system (note this will not be using ASM - but will be based on NetApp NFS)
1. Install GRID 11.2.0.3
- installed acorss two nodes, Binaries can be shared
- voting disks / cluster rigistry MUST be shared
2. Install Database Software for RAC
- Binaries cannot be shared and must be installed on each node independently
3. Configure the GRID for database (database / listeners)
4. Clone over the stand alone system (clone database as RAC)
I will be using SCAN - and therefore would expect all the web services / concurrent manager nodes to point to the SCAN hostname as opposed to individual host names.
RAC/ASM Clusterware Installation :: ORA-03114 / Not Connected To ORACLE Error With Oracle DB Installation
Dec 3, 2012I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies View RelatedInstallation :: Oracle Database Express And Other Editions Installation Doc Difference?
Mar 20, 2013My 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?
RAC/ASM Clusterware Installation :: Oracle RAC Installation With Guest OS OracleLinux6 On Virtualbox / Mac OS
Jun 7, 2013I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
RAC/ASM Clusterware Installation :: Oracle 11GR2 Rac Installation In Vmware
Aug 28, 2013I am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
Installation :: Oracle 11G Database For 64 Bit Windows Installation Error
May 6, 2013I 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 RelatedRAC/ASM Clusterware Installation :: Oracle Grid 11g R2 Installation
Jul 11, 2013I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
View 2 Replies View RelatedRAC/ASM Clusterware Installation :: Oracle Rac 11g Installation?
Sep 16, 2013Am planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
View 4 Replies View RelatedInstallation :: Oracle 10g Installation Cannot Continue
Jul 10, 2012When i am trying to install oracle database 10g, it is giving following error.Error in writing to directory :
c:Users:
ensure that this directory is writable and has atleast 55MB of disk space ,installation cannot continue.
What Are The Steps To Follow To Refresh The Database
Jul 26, 2012I am the junior DBA first time i need to do Database Refreshment on UNIX platform.
1. Database Names are different and mount points are different.
2. Synonyms and dblinks are should be retained.
How to do this and what are the steps i need to follow.
Upgrade :: Post Upgradation Steps To Run Scripts
Apr 7, 2013i upgraded oracle db from 11.2.0.2.0 11.2.0.3.0 on linux using dbua. after completion of the up gradation what are the post upgradation steps. does i need to run any scripts.
View 4 Replies View RelatedSteps For Adding Entry To Orapwd File
Jul 6, 2010review/correct my steps for adding an entry to the orapwd file.Is there an environment variable I need to set to tell it the name of the password file. In addition, how do I get a "user" in the password file when orapwd accepts file, password and entries as paramaters. Does this mean I need to give user "sys" sysdba privs?
USERNAME SYSDBA SYSOPER
------------------------------ ------ -------
SYS TRUE TRUE
/oracle/10.2.0.1.0/dbs> orapwd file=orapwd_pri password=sys entries=50;
/oracle/10.2.0.1.0/dbs> ls -tl orapwd_pri
-rwxrwxr-x 1 oracle dba 7680 Jul 06 12:09 orapwd_pri
/oracle/10.2.0.1.0/dbs> sqlplus "/ as sysdba"
SQL> grant sysdba to xxx;
grant sysdba to xxx
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
Is there a special way I have to name the file or setup a env to find it?
SQL & PL/SQL :: Query To Fetch Steps Of Test Having Recursive Calls To Other Tests
Jul 17, 2012I am working on the quality center oracle database to write a query that fetches all steps of a test case including the ones having calls to tests. Structure of table is explained below. I've made up an example and attached it as an image to this post. This image also has the expected result of the query I want to write.
Table Name: STEPS (This table contains steps belonging to tests. Some steps are simply calls/links to other tests)
Columns:
STEP_ID (primary key - integer)
STEP_NAME (char)
STEP_DESC (char)
ORDER (integer)
TEST_ID (reference to table TEST.test_id)
[code].......
Referring to the example (see attached image), I'm looking to write a query that gives me all steps (including steps from called tests) of the test - "Empty trash from mailbox" in the correct order.
To start with I can write the following query to get steps of the test - "Empty trash from mailbox".
SELECT * FROM steps WHERE test_id = (SELECT test_id FROM test WHERE test_name = 'Empty trash from mailbox')
Automatic Storage Management :: Steps For Moving Files Between ASM Diskgroups In 10g Or 11g
Jan 16, 2013the steps for moving the files between ASM diskgroups in 10g or 11g?
View 4 Replies View RelatedData Guard :: Right Steps To Perform Failover In Case Primary Database Gets Fail
Jan 10, 2011i have Oracle 10g data guard set up on windows environment.....i need to know the what are the right steps to perform failover in case the primary database gets fail.
View 4 Replies View RelatedPerformance Tuning :: Order Of Steps In Execution Path And Order Of Predicates In The Plan
Mar 20, 2012Which step in the following plan is the first step of execution
I reckon it is "TABLE ACCESS BY INDEX ROWID| BANK_BATCH_STATE"
Is that correct?
In the "Predicate Information (identified by operation id):"
section the predicates - access and filter for the step "TABLE ACCESS FULL | PYMNT_DUES" are displayed first
Isn't there any relation between the order of execution steps and the order in which predicates are displayed?
Execution Plan
----------------------------------------------------------
Plan hash value: 538700484
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2364 | 15 (14)| 00:00:01 |
|* 1 | FILTER | | | | | |
| 2 | HASH GROUP BY | | 1 | 2364 | 15 (14)| 00:00:01 |
| 3 | NESTED LOOPS | | 1 | 2364 | 14 (8)| 00:00:01 |
| 4 | NESTED LOOPS | | 1 | 2313 | 13 (8)| 00:00:01 |
| 5 | NESTED LOOPS | | 1 | 2281 | 12 (9)| 00:00:01 |
| 6 | NESTED LOOPS OUTER | | 1 | 2255 | 11 (10)| 00:00:01 |
|* 7 | HASH JOIN | | 1 | 175 | 6 (17)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | INDX_2 | 12 | 612 | 2 (0)| 00:00:01 |
|* 9 | TABLE ACCESS FULL | PYMNT_DUES | 43 | 5332 | 3 (0)| 00:00:01 |
| 10 | VIEW PUSHED PREDICATE | | 1 | 2080 | 5 (0)| 00:00:01 |
| 11 | NESTED LOOPS | | 1 | 154 | 5 (0)| 00:00:01 |
| 12 | NESTED LOOPS | | 1 | 103 | 4 (0)| 00:00:01 |
|* 13 | TABLE ACCESS BY INDEX ROWID| BANK_BATCH_STATE | 1 | 32 | 2 (0)| 00:00:01 |
|* 14 | INDEX RANGE SCAN | INDX_BBS_1 | 3 | | 1 (0)| 00:00:01 |
|* 15 | TABLE ACCESS BY INDEX ROWID| DAILY_CHECK | 1 | 71 | 2 (0)| 00:00:01 |
|* 16 | INDEX RANGE SCAN | INDX_SEARCH | 1 | | 1 (0)| 00:00:01 |
|* 17 | INDEX RANGE SCAN | INDX_2 | 1 | 51 | 1 (0)| 00:00:01 |
|* 18 | INDEX RANGE SCAN | INDX_IAM_SR_NO | 1 | 26 | 1 (0)| 00:00:01 |
|* 19 | INDEX RANGE SCAN | INDX_2 | 1 | 32 | 1 (0)| 00:00:01 |
|* 20 | INDEX RANGE SCAN | INDX_2 | 1 | 51 | 1 (0)| 00:00:01 |
-----------------------------------------------------------------
Data Guard :: Failover Standby Rac / Share Steps For Failover
Aug 26, 2010In my production -- we have 3 nodes Primary RAC with 2 Nodes Physical secondary Standby RAC. Due to some reason we will have to failover means 3 nodes Primary Standby RAC to 2 Nodes secondary physical Standby RAC. share Steps for Failover ( not switchover) from 3 Nodes Primary RAC to 2 Nodes Physical Standby RAC. I know this is generic and can be find from google but issue is how can failover from 3 nodes primary standby rac to 2 nodes secondary physical standby rac.
View 3 Replies View RelatedOracle 10g Installation On OEL 4.5
May 8, 2012Today I am installing oracle 10g on Enterprise linux 4.5 . I am having some problem while running OUI. Having much confusion with Oracle installation .....
See Error message shows
================
Checking operating system requirements ...
Expected result: One of redhat-3,redhat-4,SuSE-9,asianux-1,asianux-2
Actual Result: redhat-4
Check complete. The overall result of this check is: Passed
Installing OEL but shows actual result was redhat-4
--------------------------------------------------------------------------
CODEChecking for libaio-0.3.96; found Not found.Failed <<<<
Checking for shmmni=4096; found shmmni=-2147483648.Failed <<<<
Checking for libaio-0.3.96; found Not found.Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
here showing -ve value many times i changed values . Still error is here ....
My question is
1) by default OEL having all required RPM's but why it requires LIBAIO.
2) Installing OEL but shows actual result was redhat-4
Oracle 11.2 Installation
Mar 12, 2011I have update from Oracle 11.1 to 11.2 - but i cant see the new version
when i type: `Select * from v$version` in pl/sql developer
i still see the old version.
Oracle 10.3 Installation On AIX 6.1?
Jul 30, 2012My business requirement is to in stall ORACLE 10.3 on IBM AIX 6.1 .
View 4 Replies View RelatedInstallation :: Oracle 10g On Win 8
Sep 23, 2013I want to install oracle 10 g on win 8 , i found way for setup at this link
[URL].......
reach till step 5 and stop as i do not found any file with this name databases tageprereqdbrefhost.xml and databasestageprereqdb_prereqsdb refhost.xml. in oracle source do not know if shall i download them and then update or what ,
Installation Of Oracle 10g
Jun 15, 2012I have installed the Oracle 10g at the following location : -
C:oracleproduct10.2.0client_1NETWORKADMIN
But I was trying to ping Oracle Client from Command Prompt. See Below : -
c:Oracle>tnsping SONIA
ERROR IS COMING no listener
MINE tnsnames.ora File : -
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
SONIA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sonia)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SONIA)
)
)
What this error means? connecting to the ORACLE 10g. I have studied on the net that for Oracle to connect three ora files need to be there. But in my ADMIN Folder two files are created by Oracle Configuration Tools names SqlNet.ORA , TNSNAMES.ORA. LISTENER.ORA file is not created.
RAC/ASM Clusterware Installation :: Pre-installation Check Fails On Local Nodes?
Oct 1, 2013I am setting up a RAC cluster in Oracle 11.2.0.3 on two Windows 2008R2 nodes.I have completed all the pre-installation tasks would like to verify this by running:cluvfy comp sys -p database -n allusing the standalone download of cluvfy - I haven't installed any Oracle software as yet. This completes successfully on the remote node but fails on the local node (whichever one I run it from).
There is a lot of output but these seem to be the key problems: [1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [WindowsSystem.deleteService:876] _WS_ deleteService2: node PRDAT217 Service OracleRemExecService result: 0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:99] The status string is: 0[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:112]
[code]...
RAC/ASM Clusterware Installation :: Multiple Cluster Installation In Blade Server?
Dec 6, 2012I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.
View 1 Replies View RelatedOracle 9i And 11g Installation On Same Windows
Nov 21, 2010I am facing strange problem, I installed 9i and 11g on same machine which is running windows server 2003 service pack 2. I set ORACLE_HOME and PATH of both versions different and both are installed properly.
But when i try to create new database using oracle 9i DBCA after reaching step 8 DBCA becomes unresponsive whereas i am able to create new database using Oracle 11g DBCA. After searching the entire net i am not able to troubleshoot the problem. Moreover in both version i am able to access using CMD and i got the connectivity.
I configure the listener for both on different port but when i run oracle 9i the screen shows first connectivity of oracle 11g sql* plus after that it is going to connect to oracle 9i this is my second issue. My system RAM is 1GB total is this is also be the reason for the above problem.
Oracle DB / Schema Installation For SAP BO
Nov 29, 2010I am going to do the SAP-BO Setup in our landscape, how to do the following....
1. How to do the Oracle installation for BO in AIX (UNIX)? Is it a normal installation? or different? BOE-Application will be installed on Windows. So the DB suppose to communicate with the Application.
2. How to do the sizing of database?
3. How to create a database schema in oracle with proper parameters? I need to create 7 schema.
4. What are the parameters we have to maintain in Oracle - init.ora file which is required for BO ?
ERROR While Installation Of Oracle
Dec 24, 2011I m getting error while installing ORACLE 10.2.0.1 client on windows error is as follows :"The path is more than 1023 character....."
------------------------------------------------------------------------------
my PATH variable contains following value
D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\CA\SC\CAWIN\;E:\oracle\product\10.2.0\db_1\bin;C:\Program Files\Common Files\NetSarang;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin
