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.
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
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?
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?
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.
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 ...!!!
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.
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?
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.
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
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.
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…?
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'
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
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?
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
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
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.
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 .
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?
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
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....
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.?
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.
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'.
