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

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…

Continue

Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…

Continue

Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…

Continue

Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…

Continue

Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service