RAC/ASM Clusterware Installation :: How To Copy ASM Files On Host Filesystem

Oct 15, 2013

There is a question come up in my mind that can we perform the copy/delete/move of ASM files to the host filesystem while the ASM instance is down. For instance... To copy the file ASM file through AMCMD utility when the ASM instance is running.

ASMCMD> cp spfilenode.ora /u01copying +DATA/NODE/spfilenode.ora -> /u01/spfilenode.ora 

Now my question is, Can I copy/delete/move that file on OS filesystems when the ASM instance is down.

View 3 Replies


ADVERTISEMENT

Server Administration :: Copy Many Files From ASM To FileSystem

May 1, 2013

I have got backup pieces in ASM, I guess about more than 100 files. Now, I need to copy all of them from ASM to FileSystem, there are 2 methods still now:

1- Copy from ASM to FileSystem using cp command.
2- Copy from ASM to FileSystem using DBMS_FILE_TRANSFER.

But:

In the first method, when I copy one file, I took more than 1 minute, so the following script would take me more than 1 days (I guess so).

#!/bin/ksh
#
# This script copies files from FRA on ASM to local disk
#
ORACLE_SID=+ASM2
ASMLS=/vasgatedb/app/vsgbkp/asm_ls.txt ##{ASM files list}

[Code]...

The second method, DBMS_FILE_TRANSFER took me less than 1 second to copy one file completely.

sys@VSGDB> set timing on
sys@VSGDB> exec dbms_file_transfer.COPY_FILE('asm_dir','level_0_vsgdb_9998_813844797.bkp','fs_dir','level_0_vsgdb_9998_813844797.bkp');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.38

Of course, I wish I used the second method as soon as possible, however, said I below, I've got about ~200 files, and I could not copy one by one file.

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Can SCAN IP Be Used For Ftp Of Files

Sep 25, 2013

I would like to know, if SCAN IP can be used by clients or applications to FTP files to either of the database nodes? 

View 3 Replies View Related

RAC/ASM Clusterware Installation :: OEM Grid Control Files For Oracle Database 10gR2

Jan 22, 2013

I am trying to setup my environment to prepare for hands on DBA exercises from an OCM handbook for 10g -OCM:Oracle Database 10g Administrator Certified Master Exam Guide

I need access to the following files
gc_10205_part1of2.zip, gc_10205_part2of2.zip for 32 bit linux

Apparently the above along with other Grid software was once attainable from the link below but sometime between this year and the last Oracle decided to remove this and other software from public access. URL.....

I doubt Oracle will hear my plea - educational purposes only - so given I want access to the software only.

View 2 Replies View Related

Forms Host Command Cannot Copy To Network Drive

Oct 3, 2013

I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.

The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow

net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf

Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:

copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf

Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Pre-installation Check Fails On Local Nodes?

Oct 1, 2013

I 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]...

View 6 Replies View Related

RAC/ASM Clusterware Installation :: Oracle RAC Installation With Guest OS OracleLinux6 On Virtualbox / Mac OS

Jun 7, 2013

I 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.

View 0 Replies View Related

RAC/ASM Clusterware Installation :: Multiple Cluster Installation In Blade Server?

Dec 6, 2012

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

RAC/ASM Clusterware Installation :: Oracle 11GR2 Rac Installation In Vmware

Aug 28, 2013

I 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.

View 15 Replies View Related

RAC/ASM Clusterware Installation :: Candidate Disks Disabled During Installation?

Nov 17, 2013

We're trying to utilize Oracle RAC 11.2. We want to have two servers in our grid. These two server are installed on a VM using Hyper-V software.

common storage for asm is also developed on a VM using FreeNAS software.Now, when we try to install Grid Infrastructure the disk that is recognized as a extra drive in both servers are disabled and we can't select it as ASM storage. The OS we're using is Windows Server 2008 R2.I have to say the IP requirements are considered and the servers have two IPs.

View 0 Replies View Related

RAC/ASM Clusterware Installation :: Oracle Grid 11g R2 Installation

Jul 11, 2013

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

RAC/ASM Clusterware Installation :: Oracle Rac 11g Installation?

Sep 16, 2013

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

Server Administration :: Installation Of Oracle 11 G - Host OS Vista

Jan 4, 2011

Im trying to install oracle 11g release 2(11.2.0.1.0) on oracle solaris 10(x86-64) on vmware on my laptop and my host OS is vista home basic ...

i successfully installed solaris on vmware but while im trying install 11g on it,its show .oui:syntax error at line 1: '|' unexpected.

i follow oracle documentation as well as OFA...

View 3 Replies View Related

RAC/ASM Clusterware Installation :: ORA-03114 / Not Connected To ORACLE Error With Oracle DB Installation

Dec 3, 2012

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

Clusterware :: Network Socket Files?

Oct 9, 2012

We were facing some issue with crs startup and had to delete network socket files present in "/var/tmp/.oracle/".

what these "/var/tmp/.oracle/*" files do?..What informations are there in these files?

View 2 Replies View Related

Forms :: Copy Files From One Location To Another In 6i

Sep 9, 2008

I want to copy files from one location to another in forms6i on when button pressed.i m using the following code.

DECLARE
cpf_source VARCHAR2(500) := 'c: est.txt';
cpf_target VARCHAR2(500) := 'c:data';
begin
WIN_API_UTILITY.copy_file(cpf_source,cpf_target,TRUE);
end;

But i press the button it generates FRM-40734,

internal Error : PL/SQL error occurred.

View 5 Replies View Related

SQL & PL/SQL :: Copy Some Archivelog Files Between 2 Database Server

Sep 27, 2011

I wanted to copy some archive log files between 2 DB Server.Steps:

1) Edited the Local and Remote DB's TNSNAMES file and modifyied like below.

bookstore =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.100.28)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BOOKSTORE)
)
)

2) Created a Source Directory --> DR1
3) Created a Target Directory --> DR2
4) Created a DB Link
CREATE DATABASE LINK LINK1 CONNECT TO <username of the Remote DB> IDENTIFIED BY <Password> USING '<Remote DB Name taken in the TNSFILE>.
5) In the Local Server I had written the below command.

create or replace procedure proc1 is
cursor c1 is select recid,substr(name,37) "ARCH_FILE" from v$archived_log;
var1 c1%rowtype;
begin
open c1;
fetch c1 into var1;
[code]...

It is working, but not coping the Files from Local To the Remote.

View 22 Replies View Related

JDeveloper, Java & XML :: Copy Files Into System Directory?

Mar 15, 2011

I am on a font manager project. One of the features is to install the new font file. My understanding by "install" is to copy the file to the system directory Windows/fonts (correct me if I am wrong in this part). When I tried to use the java copy file api to do so, not surprisingly I got the access denied exception.

1. How can I do a "force-copy" of file into the system directory?

2. If that's not proper way, how can I create a "shortcut" like a softlink of the file into the system directory?

View -1 Replies View Related

RAC/ASM Clusterware Installation :: Upgrade 11.2.0.1 GI EE To 11.2.0.3 SE?

Jul 9, 2012

Is it possible to upgrade GI 11.2.0.1 Enterprise Edition version to 11.2.0.3 STANDARD EDITION?

We have 2 Node RAC with 10.2 DB SE. Last time I think by mistake or not knowing the licensing information GI was upgraded to EE 11.2.0.1 by somebody or may be whatever version of GI is used, it has nothing to do with the license?

I have heard that I can upgrade Grid Infrastructure, but to Standard Edition. Does GI also comes with SE and also just want to know that can I perform this upgrade?

View 11 Replies View Related

RAC/ASM Clusterware Installation :: GI Upgrade From 11.2.0.1 To 11.2.0.3?

Jul 4, 2012

2 Node RAC Prod. GI= 11.2..0.1 , DB = 10.2.0.4 SE

I want to upgrade (out of place) Grid Infrastructure to latest version of 11.2.0.3 and then PSU on top of that.

GI HOME and DB HOME are separated. Database I want to upgrade later on, not with this clusterware upgrade. I have download p10404530_112030_Linux-x86-64_3of7.zip from MOS for upgrading GI.

grid@db1p [rec]: /home/grid > crsctl query crs softwareversion
Oracle Clusterware version on node [db1p] is [11.2.0.1.0]
grid@db1p [rec]: /home/grid > crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]grid@db1px [ec]: /home/grid > sqlplus / as sysasm

[code]....

1) Is this the correct p10404530_112030_Linux-x86-64_3of7.zip to upgrade GI from 11.2.0.1 to 11.2.03?

2) Do I need a COMPLETE DOWNTIME to upgrade GI on 2 node RAC where DB is STANDARD EDITION but Clusterware is 11.2 as you have seen above..

3) Will this ASM version will also be upgraded along with GI upgrade installer or it must be upgrades separately after GI Upgrade?

View 4 Replies View Related

RAC/ASM Clusterware Installation :: ONS Is Not Running

Dec 27, 2012

When I use 'ONSCTL PING' to test the ons status, it says: configure localport and remoteport directives and attempt to start ONS server again.ons is not running.The content of D:app11.2.0gridopmnconfons.config is:

localport=6100          # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200          # line added by Agent
nodes=rac1:6200,rac2:6200          # line added by Agent

The content of D:app11.2.0gridopmnconfons.config.rac2 is:
localport=6100          # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200          # line added by Agent
nodes=rac1:6200,rac2:6200          # line added by Agent

The configuration file is almost the same in rac1.But the output of 'srvctl status nodeapps' is :

ons is enabled
ons is running on node1:rac1
ons is running on node2:rac2

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Endianess Conversion?

Oct 13, 2013

tried to mount a big endian asm disk (AIX for example) on little endian env (linux x86)? I have a disk that KFED is able to read but ASM is unable to mount it due to endianess incompatibility. 

 from the KFED read: kfbh.endian:                          0 ; 0x000: 0x00kfbh.hard:                          130 ; 0x001: 0x82kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt:                          1 ; 0x003: 0x01kfbh.block.blk:                       0 ; 0x004: blk=0kfbh.block.obj:                     128 ; 0x008: file=128kfbh.check:                  1999209486 ; 0x00c: 0x7729840ekfbh.fcn.base:                        0 ; 0x010: 0x00000000kfbh.fcn.wrap:                        0 ; 0x014:

[code]...

View 8 Replies View Related

RAC/ASM Clusterware Installation :: 10g To 11g Rdbms Upgrade?

Jun 15, 2013

We try to upgrade the 10g to 11g oracle instance and asm instance.Below steps we r done;

1)First we are install the 11.2.0.3  database and grid infrastructure in separate home.

2)after that i try to upgrade asm instance so i drop old 10g asm localconfig   cd  $ORACLE10g_HOME./localconfig deletecd $ORACLE11g_HOME./localconfig add   but here i can not find localconfig Note:database and  grid installed without error....

3)Even we are try dbua but it run 10g dbua we are not able to run dbua for 11g

4)inventory is corrupted how to recreate inventory

5)provide the steps for upgrade 10g asm to 11g asm 

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Can Use 64 Bit OS (Solaris X86) In PC With VMware

Mar 22, 2013

Can I use 64 bit OS (Solaris x86) in my PC with VMware. As many software available in 64 bit but not in 32bit.

If I install 64 bit OS , Oracle DB whether it can crash the system or not

View 4 Replies View Related

RAC/ASM Clusterware Installation :: Patching Cluster From 11.2.0.1 To 11.2.0.3?

Aug 15, 2012

I'm a long time Oracle DBA but have only recently started with RAC and have never done any patching or upgrades in a RAC environment.

My environment consists of a 2 node RAC cluster, and 2 physical standbys at separate remote locations.

The database, GI, ASM, and clusterware are all at version 11.2.0.1.

I want to upgrade all components to the latest patchset which is 11.2.0.3. Eventually I also want to apply the latest PSU.

Can I do this without down time? It is a mission critical database where downtime could conceivably endanger lives. If it can't be done with zero downtime, then downtime must be kept to an absolute minimum (minutes, not hours).

I suspect the clusterware needs to be patched first and I do not know whether I can do it on one node at a time.

View 2 Replies View Related

RAC/ASM Clusterware Installation :: How To Configure DNS For Using Oracle GNS

Sep 24, 2012

I need some professional article about how to configure DNS for using Oracle GNS with explanation.

I want to understand the role of DNS server for GNS.

I tried to search but what I found is not enough or they are not written with accuracy.

View 2 Replies View Related

RAC/ASM Clusterware Installation :: ASM On RHEL6 Using Udev

Dec 6, 2012

I'm installing Oracle RAC 11.2.0.3 on RHEL6.3. Since the asmlib RPMs are not provided any more (for RHEL6) I am now able to use either a whole disk or a partition.

which method is the better one, what are the advantages and disadvantages of these methods?

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Size Of LUNs For ASM

Nov 11, 2013

ENV: Oracle 10g R2 EE on ADM, RHEL 5.8 64bit 

Is there a difference performance wise if ASM gets two LUNs of 1.7TB (DATA) and 0.6TB (FRA) respectively compared to 17 LUNs of 100GB each (for DATA) and 6 LUNs of 100GB each (for FRA)? Is there a recommended size from Oracle? 

View 6 Replies View Related

RAC/ASM Clusterware Installation :: Installing Oracle 11g With ASM?

Feb 28, 2013

Here we are going to configure a new set up on new hardware :

clients requirements :

oracle 11g with ASM :
Number of instance = Single database
Platform = IBM AIX 6.1

View 6 Replies View Related

RAC/ASM Clusterware Installation :: 11g R1 Rac Installation

Jun 13, 2012

I have a production database, the manager ask me to take the test Server to make an Oracle RAC with the Production Server.

Can I Install the RAC 11g R1 only in one Server (test server) ? and then include the Second Server (production)?

View 3 Replies View Related







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