January 2012 Blog Posts (18)

Oracle Hyperion Apps Cloning

1.       Backup of  source APPS
A.      Go to shared services console àApplication GroupàFoundationàselect desire application like “HYP” àfrom the left pane select all options and click on Define Migration buttonàclick nextàwrite down any name like “HYP_bak” and click on next buttonàclick on execute migration button
B.      Check status report, this job should be completed normal and if this job fail then check log file.
C.      Copy “HYP_bak”…
Continue

Added by Muhammad Atif Akram on January 25, 2012 at 8:40pm — No Comments

After Test-Failover, make NEW Primary Standby again

Maybe we want to test Failover, although the Primary is working fine. After the failover succeeded, we have an OLD Primary then and a NEW Primary. There is a well documented way to convert the OLD Primary into a Standby. This procedure is called Reinstate. This posting shows how to make the NEW Primary a Standby again:…

Continue

Added by Uwe Hesse on January 24, 2012 at 12:51pm — 1 Comment

Failover to Snapshot Standby

Have you ever tested the failover to your Snapshot Standby? Maybe you should:

http://uhesse.wordpress.com/2012/01/14/failover-to-snapshot-standby/

Added by Uwe Hesse on January 24, 2012 at 12:49pm — No Comments

Administrating Asm Instance

Daha önceki ayzılarımızda da belirttiğimiz gibi asm bir instance dir.Yani kendine has memeory alanları vardır.Nasılki oracle instance verileri yönetiyor , tutuyor ve erişimii sağlayıp kouyorsa, asm instance de aynı şekilde storage yönetimi için geliştirilmiştir.Ancak bir makinada birden fazla oracle instance olabilir.Neticede oracle instance database i yönetir.Ancak bir makinada sadece bir asm instance olur ve o makinanın gördüğü storage yapılarını asm instance yönetir.Şekil1 de asm instance…

Continue

Added by Özcan YILDIRIM on January 24, 2012 at 5:24am — No Comments

Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5) Video Tutorial

Bu yazımda Oracle Database 10g Release 2 (10.2.0.1)  yi  Red Hat Enterprise Linux 5 (RHEL5) üzerinekurulumdan önce yapılması gereken işlemlerden bahsedeceğim.

İlk olarak Red Hat kurulumunda yapılması gerekenlerdenbaşlayalım.

Kurulum esnasında Swap alanımızı en az 2G olarak veriyoruz ve secure linux u disable olarak seçiyoruz.

Yüklenecek packageler ise,

  • GNOME Desktop Environment
  • Editors
  • Graphical Internet
  • Text-based…
Continue

Added by TiryakiBurak on January 20, 2012 at 7:32am — No Comments

Oracle Clusterware Troubleshooting

Oracle Clusterware monitör etmek, problem tespiti ve sorun gidermek aslında cluster servislerini ve alertleri gerektiği gibi yorumlamaktan geçer.Ancak bunların öncesinde cluster sorunlarında aklımızdan çıkarmamız gerekn bir kural vardır.Oracle Clusterda ilk kontrol edilecek olan Cluster node ların system zamanlarının aynı olması yani time synchronization.Eğer network time protocol  (NTP) kullanılıyorsa aşağıdaki gibi time synchronization sağlanabilir.



$ vi   /etc/sysconfig/ntp…

Continue

Added by Özcan YILDIRIM on January 20, 2012 at 4:08am — No Comments

Online SOA - AIA Training-Instructor lead

Hi All,

Greetings from TutorsOnInternet.

Training Schedule:28,29 January & 4,5 ,10,11February2012 [Weekends Only] 

Course contents:-



Day 1:

• Introduction and Concepts of SOA

• -Definition of SOA

•-Standards and Specifications that make SOA

• -Describe SOA Reference Architecture

•-Understanding SOA Suite 11g Product

• -Understanding Service Design Considerations and different Service…

Continue

Added by Nisha on January 14, 2012 at 4:31am — No Comments

Create The DB Link between SOURCE to TARGET instances in FSG

1. Create  The DB Link  between  SOURCE  to  TARGET instances.

 

 

Query :

 

* All the FSG work that we have developed in FINSIT (Source) are needs to be transferred to SAND and UAT (next week).

 

 

Solution :



Source Database / Instance =  SSEFINST

Target Database / Instance  =  SSESAND

 

 

 

Step 1 :  Add the TNS…

Continue

Added by sadhanand kasetty on January 11, 2012 at 6:00am — No Comments

Create Physical standby database create… Data guard 10g database

Create Physical standby database create… Data guard 10g database

 http://download.oracle.com/docs/cd/B19306_01/server.102/b14239.pdf

 

  1.  Os versions / Database Versions / Patchset Level should be same.
  2.  SID should be  same , if not use convert parameter in pfile.
  •  Here SID = CLONE  is the same between two servers.…
Continue

Added by sadhanand kasetty on January 11, 2012 at 5:48am — 1 Comment

Database up gradation from 10g ( 10.2.0.4 ) to 11g ( 11.1.0.7) in Oracle Application 11i

Step 1 :   Down Load the Database Software  from   (edelivery.oracle.com/   or.  http://www.oracle.com/tehnology/software/products/database/index.html

  1.  11g Database  ( Base versions 11.1.0.6)  --- V14215-01_1of2.zip
  2. Oracle Database 11g Examples ( formerly Companion )  ---- aix.ppc64_11gR1_examples.zip
  3. 11g Database (11.1.0.7) Patch set …
Continue

Added by sadhanand kasetty on January 11, 2012 at 5:30am — No Comments

Legacy Forms V2/3 Applications & RPT Reports that needs to be converted into the latest web-based Oracle applications

Our PL/SQL Parsers can help to transform hundreds / thousands of such programs with minimal effort!

 

Oracle FormsV2/3  PLSQL Parser

 

  • SQL*Forms V2/3 applications written to run as character-mode applications with V2-style Triggers are quickly converted into PL/SQL code with 100% Accuracy & Success.

 

  • Save huge amount of Time & Cost by using our Parser allowing hundreds/thousands of forms to be…
Continue

Added by LongBridge Corporation on January 10, 2012 at 12:30am — No Comments

RAC 11gR2; Guaranteed Restore Points with Flashback Logging Disabled

Restore Points and Guaranteed Restore Points:

Before using flashback database solution to revert any changes made on the database, you can give a name to the SCN or specific Time until which you want to restore. This name you give is called a restore point.

A normal restore point enables you to flash the…

Continue

Added by Wissem EL KHLIFI on January 9, 2012 at 7:04am — No Comments

Oracle Asm Architecture

Oracle Asm Architecture and recommended knowhow of asm components ara explained by ozcan-yildirim.blogspot.com/2011/12/oracle-asm-architecture.html

Added by Özcan YILDIRIM on January 8, 2012 at 3:10pm — No Comments

RECOVER CONTROLFILE

ASSUME THAT YOU ARE DOING SUM WORK ON DATABASE AND SUDDEN DATABASE GET SHUTDOWN DUE TO CONTROL FILE ERROR,



STEP-1



GO TO THE PATH WHERE THE CONTROL FILE IS EXIST



DELETE THAT CORRUPT CONTROL FILE

COPY…

Continue

Added by Rohit Khurana on January 8, 2012 at 2:30am — No Comments

HOW TO RECOVER CONTROL FILE WITH THE HELP OF RMAN ??

STEP 1



C:\>SQLPLUS SYS/TIGER@ORCL AS SYSDBA



STEP 2



BEFORE STARING BACKUP ,,,,, CHECK MUST THE SYSTEM SHOULD BE IN ARCHIVE LOG MODE





WRITE IT !



SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            C:\oracle\ora92\RDBMS

Oldest online log…

Continue

Added by Rohit Khurana on January 8, 2012 at 2:30am — 3 Comments

Oracle Clusterware Yönetimi

Oracle Clusterware Administration Comand Referance and importand notes,

http://ozcan-yildirim.blogspot.com/2012/01/oracle-clusterware-yonetimi.html

Added by Özcan YILDIRIM on January 5, 2012 at 2:19pm — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service