Configuring Udev Rule For Raw Disks?
Jan 1, 2013
I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.
CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",
[code].....
View 8 Replies
ADVERTISEMENT
Jun 27, 2012
We have Exadata -V2 quarter rack with High Performance Disks. We applied EHCC's various compression methods on some of the table's partitions.
Now we are setting up Exadata Expansion Rack - High Capacity Disks. Post implementation, we would be moving older partitions to new Expansion Rack wherein compressed partitions are also included.
In this case, would there be any impact on the compression ratio as the expansion rack is having high capacity disks.
And, moving partition method would be same as it is for non-exadata database i.e. "alter table <table_name> move partition
<partition_name> tablespace <tablespace_name>"
View 2 Replies
View Related
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
Feb 20, 2012
Is there any rule in documentation, when create partition index? For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?
View 1 Replies
View Related
Aug 3, 2011
I have 2 questions :
1. How many oracle mechanism can link with oracle send mail mechanism ??
2. Any samples which the oracle send mail mechanism to run with some oracle alert mechanism.
View 3 Replies
View Related
Aug 10, 2013
we are in the migration of oracle apps 11.5.9 [version] , while uploading AR open invoices we used auto accounting rule for revenue account , but we did this changes its not taking an effect , same revenue a/c we uploaded is uploaded , but the auto accounting is not taking an effect ,
for a work around we migrated the data ! but we would be the root cause and possibilities why it hasn't worked ?
But this auto accounting rule worked in CRP & UAT as well ...!!!
View 2 Replies
View Related
Sep 3, 2012
I am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.
Item Type = CONCSPL
Item Key = 086937-15990
User Key =
Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)
[code]....
Bottom line is all notifition should be successfully process and send to dedicated person.
View 2 Replies
View Related
Jan 10, 2012
I am a new Oracle DBA that has been tasked with creating some single node databases for our programmers to connect to. I have never built a database, only upgraded. I will be using a Dell 610 with 10.2.0.4 software. I have been reading the install guides but cannot find a definitive answer for how to create the raw partitions. I have a SAN that I can utilize and my current db is set up with RAID 6 like so:
Disk 2 300 GB 1 Extended 300 GB and 5 logical, 100MB, 30 MB, 100 GB, 100 GB, 100 GB
Disk 3 100GB 1 Extended 100 GB and 3 logical 100 MB, 30 MB, 100 GB
why the old DBA partitioned this way? I am not good with storage and know that I need to understand before I build new databases so I do not duplicate something that is wrong. I was reading articles that recommend SAME but would not know how to do that on the SAN.
I will be using data pump to export the database and import to the new server. I was looking at using transportable tablespaces to do this. Would you recommend that from the cluster to the standalone?
View 4 Replies
View Related
Oct 21, 2013
Is there any command to identify the disks are HC OR HP ? Indirectly i could find with the following exercise -
$ grep -i MACHINETYPES /opt/oracle.SupportTools/onecommand/databasemachine.xml <MACHINETYPES>X2-2 Half rack</MACHINETYPES> ASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED NORMAL N 512 4096 4194304 18235392 10597264 2605056 3996104 0 N DATA/MOUNTED NORMAL N 512 4096 4194304 2087680 2085808 298240 893784 0 Y DBFS_DG/MOUNTED NORMAL N 512 4096 4194304 27240192 18871860 3891456 7490202 0 N RECO/ = 45TB >>
[URL] ....... >> Page 5 >> HP SAS disks
View 2 Replies
View Related
Jul 25, 2010
Regarding 11gR2 RAC, ASM, and NFS. Installing 11gR2 Grid Infrastructure and 11gR2 RAC on OEL 5.5 servers with storage supplied by NetApp NFS shares over TCP/Ethernet.
How do I mount NFS file systems as block devices so ASM will use them?
It is my understanding that Linux mounts NFS file systems as anonymous file systems rather than block devices. ASM requires block devices. The only way I know to have Linux treat an anonymous file system mounted over NFS as a block device is to subsequently mount it as a loop device.The Oracle 11gR2 documentation states, "ASM does not support loop devices". Without defining NFS mounts as loop devices, oracleasm createdisk complains the given file on the NFS mounted file system is not a block device when i run
/usr/sbin/oracleasm createdisk DATA /oradata/prod/data/disk01
where /oradata is an NFS mount from a NetApp volume defined in /etc/fstab and disk01 was created with the dd command.I followed the steps in section 3.3.1.2 'Creating Files on a NAS Device for Use with Oracle ASM' of the Oracle guide..
When I use asmca, it does not find any candidate disks with the search path set accordingly.If successfully implemented ASM using NFS shares for database disk groups from a NAS, Steps I followed are below.
In /etc/fstab:
server-ip-address:/vol/data /oradata nfs rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
-- mount and verify. /oradata is mounted with specified options.
# mount -a
# mount
[code]...
Command fails with error message "File /oradata/prod/data/disk01 is not a block device." None of the OUIs (grid installer, asmca, or dbca) identify any disks as ASM candidate disks with the search string '/oradata/prod/data/*'. I also tried using '/*', '/oradata/*', '/oradata/prod/data/*' to no avail.
View 4 Replies
View Related
Aug 31, 2011
I have an Oracle database 11.1.0.6 with ASM storage.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
There is a disk group named +FRA which has only 1 disk (call it disk 0 for later references).
+FRA disk group is in type of EXTERNAL redundancy
I'd like to add another disk to +FRA disk group and copy all files stored in disk 0 to the new disk (call it disk 1 for ex.), then take off disk 0 (not use for +FRA disk group any more).
Expected result: there is only one disk 1 left in the +FRA disk group, with all the data from disk 0 and keep their original file names
View 5 Replies
View Related
Aug 27, 2011
I am trying to install 2-node 11gR2 RAC on CentOS 5.6 using VMWare Fusion. I'm in the middle of Grid Infrastructure installation and while choosing the ASM diskgroups I don't see any candidate disks but when I click on all disks i can see them but can't select them.
I tried installing the grid before and ended up with and issue running the root.sh on all the nodes so had to deconfigure the grid binaries using the rootcrs.pl and then deinstalled the grid software using the ./desintall utility.
when tried installing again ...I ran the cluvfy utility ..it doesn't show any errors.
View 2 Replies
View Related
Jan 20, 2013
We are in preparation for the purchase of equipment for two- node Oracle10g RAC (on Windows Server 2008) and I need to configure the disks on servers. We have an existing EMC VNX5500 storage and SAN 8Gb switches.
My question is with how many disks to configure servers?Originally we planned four SSD discs (two in RAID 1 for OS and two in RAID 1 for locally Oracle home) for each node/server, and everything else on storage disks (Shared Disks Storage).
Whether it is necessary to have more local disks and for what? Where should be redologs files, archivelogs files, backup files…
Whether it is better server to be configured with six SSD disks:
- two in RAID 1 for OS,
- four in RAID 10 (or RAID 1) for locally Oracle home, archivelogs files, or something else…?
View 6 Replies
View Related
Nov 12, 2010
ASM instance SID = +ASM and the database installation was under SID =rdbms112
Im just in the process of running dbca and have specified which ASM disks to use for data, but then on the next screen of the dbca, im asked for the ASMNMP password,
the password for 'oracle' user is 'oracle' but im getting this message:
"Could not validate ASMNP password due to the following error: "ORA-01031-insufficient privilages" Do you want to continue? If you contiue ASM will not be configured to be moitored by database controll "
when I was asked for privilaged operating system groups when setting up ASM
OSDBA, OSOPER and OSASM ... were all set to group 'dba'
the oracle user is in the 'dba' group
View 2 Replies
View Related
Mar 3, 2012
you have given 500gb of harddisk. how will u implement the size or how to assing the size for disks in the diskgroup.give me the best practice that is used in production
View 1 Replies
View Related
Jun 28, 2012
Normally ASMlib/oracleasm is used to prepare the disks for ASM. I just wonder, besides this tool, is there any other GUI based tool to use for preparing the ASM disks?
View 2 Replies
View Related
Jul 23, 2011
i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.
operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE
when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information
solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem
View 1 Replies
View Related
Sep 26, 2012
Below is the error returned, while configuring "emca" for "enterprise manager"
C:Documents and Settingsuser> emca -config dbcontrol db -repos create
STARTED EMCA at **** **:**:** PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
------------------------------------------------------------------------------------------
orcl is the oracle sid on my computer and database status is RUNNING
View 3 Replies
View Related
Mar 14, 2013
What do I have to do in order to configure FOP for APEX 4.2 ?
View 3 Replies
View Related
Aug 6, 2010
after configuring the rman sript when im running the script its giving the error like this
RMAN-00571:-----------------------------------------------------------------------------------------------------
RMN-OO569:--------------------ERROR MESSAGE STACK FOLLOWS-------------------------------------------
RMAN-00571:--------------------------------------------------------------------------------------------------------
RMAN-03008:error while performing automativ resync of recovery catalog
ORA-01580:error creating control backup file /disk1/oradata/car/rman/snapcf_car.f
ORA-02704:file create error unable to create file
View 1 Replies
View Related
Aug 15, 2010
How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.
View 5 Replies
View Related
Aug 18, 2011
I am trying to configure Golden Gate but i am running into the following errors while configuring. Given below is the contents of the configuration.
ggssci>edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS
[Code].....
View 1 Replies
View Related
Jun 4, 2013
On my PC I have installed Oracle 10g & Oracle Forms & Reports 6i .My PC is on LAN ,to avoid problem of dynamic ip address & tns 12514 as PC get connected & disconnected from LAN regularly I have just installed Loopback Adapter.As my PC on LAN so it have old NETWORK CONNECTION which have specific ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server.
How loopback adapter going to work & what I have to do after installing LOOPBACK ADAPTER? Can I give the same ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server on my new network connection (generated after installing Loopback Adapter) as it is on my old network connection & delete or disable old Network Connection. And come in my original LAN with same settings on new Loopback Adapters newtwork connection. Or I have to keep both network connection .
View 5 Replies
View Related
Oct 10, 2012
Refer a MOS Note for configuring data-guard on Exadata with DR server being and Exadata DBM too.
View 4 Replies
View Related
Jun 19, 2012
I have 11.1.0.7 instance running and got more 300G of storage available for the database. I would like to know what are the steps to add these disks/storage to the existing DATA asm disk group?
View 5 Replies
View Related
Apr 7, 2009
I have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.
I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report
WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
||'&ssoconn=default/oracledb/userid'
||'&report='||repid
||'&desformat=PDF'
||'&destype=CACHE'
||'&pyear='||:PARAMETER.pyear
||'&branch='||:PARAMETER.branch_id
||'&bk='||:transactions.book
||'&sno='||:transactions.srno
||'¶mform=no'
,'_blank');
From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....
How can i configure it to use only IP address.
View 25 Replies
View Related
Jun 21, 2013
We have an Oracle UCM and Oracle SES implementation.Currently there are too many tags returned for certain keywords by SES which breaks the UI,some of the tags being irrelevant too.Is there any configuration variable in SES by which these tags can be limited to say 20 most relevant tags.?
View 0 Replies
View Related
Feb 28, 2012
i want to install oracle real application cluster using shared file system and not using ASM. we are not creating LUN for our data to kept and SAN admin will give us NFS share where we will place the database.
View 5 Replies
View Related
Nov 2, 2011
i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).
Steps :
1) i installed Oracle 11g R2 Software Only.
2) Started DBCA to configure Database
3) I got a message that i need to configure Listener first.
4) I opened NETCA and add a listener ( default name LISTENER)
5) Then re-opened DBCA to start Database configuration and found the same message configure listner.
6) I went to control panel-> Services -> i found no listeners there
7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener
9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error
10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :
Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.
[code]....
View 4 Replies
View Related
Feb 14, 2013
I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.
(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)
Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.
View 2 Replies
View Related
