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

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …

Continue

Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.



Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…

Continue

Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…

Continue

Posted by Alvaro Dee on April 3, 2017 at 3:23am

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

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service