Sandeep Panchal Blog

Oracle iSetup: What is Oracle I-setup. Oracle iSetup is a data migration and reporting tool It is a part of the Oracle E-Business suite. This tool consists of the Migrator and the Reporter: What is Migrator: The Migrator helps you to migrate data from one instance of the Oracle E-Business suite to another. How to migrate data using I-setup: • Extract select data from an Oracle E-Business suite instance. Transform select attributes of the extracted data objects as per your requirements. Load data to the target Oracle E-Business suite instance. What is Reporter in I-setup Reporterhelps you to generate reports. You can Generate reports on the extracted data. You can Compare two sets of extracted data to identify differences. How to setup I-setup in Oracle E-Business suite instance (Source and Target) Source Instance – mysource Target Instance – mytarget Step 1: Copy the $FND_SECURE/target.dbc file from target server to Source server under same location Add ...

Error:   0403-057 Syntax error at line 24 : `<' is not matched. Shell script : . . . sqlplus  << EOJ . . .   "some space "EOJ Fix : Verify that there is no space before before the  'EOJ'  or 'EOF' (Closing side)...it works.

Oracle DBA: Step 2: Sql and Pl/sql. After reading my first blog. You should have some idea about database design. Lets learn some sql and pl/sql now. I think blog i am trying to provide the information about the sql and pl/sql. What is sql: SQL (Structured Query Language) is a database computer language designed for managing data in relational database management systems (RDBMS) in 1979, Relational Software, Inc (Now Oracle Corp) introduced the first commercially available implementation of SQL, Oracle V2 (Version2) for VAX computers. The most common operation in SQL is the query: You can select data from the database tables. Example: SQL> select ename from emp; This will retreive the data from emp table and column ename. Learn: Data Manipulation Language (Example Select,insert,update etc) Data Definition Language (Create/drop/alter table ) Data Control Language (Grant/Revoke) One of the best website for learning SQL is http://www.sqlcourse.com/ What is pl/sq...

First Step towards Oracle DBA: My thoughts: I think a learner DBA should not jump on the Oracle database,sql,plsql to start with. It will be really nice to understand the basics of RDBMS: (May be learnig in parallel, But donot avoid Learning database design concpets) To learn DBA from very basics you must understand the database design. Learn RDBMS concepts. Learn Normalization Relations Between Tables Best Practices in Database Design Try to Create Few tables based on some data, Normalization is an important step in database design, as it minimizes the redundancy in information. If required level of Normalization is not achieved , It will not be a good database design. If redundancy is not eliminated then more space is required to store the data. Which is not a good database design. You can google normalization and you will get lot of pages so i am not describing here. You can read from the website http://www.dbnormalization.com/ The key here is that you sh...

Hiding password in shell Scripts requires oracle connection. 1. User identified externally SQL> show parameter prefix NAME TYPE VALUE ------------------------------------ ----------- ----- os_authent_prefix string OPS$ SQL> SQL> create user ops$sandeep identified externally; User created. SQL> User sandeep will be able to connect as sqlplus / You can use the OS user to connect to Database. 2. Use Oracle wallet. Oracle gives us the option of using a secure external password store where the Oracle login credentials are stored in a client-side Oracle wallet. This allows scripts to contain connections using the "/@db_alias" syntax. Create a wallet and wallet entry for database connection. Identify the wallet location set the wallet location as TNS_ADMIN export TNS_ADMIN= create the sqlnet.ora file Create the tnsnames.ora file with the wallet entries learn about mkstore to cr...

Someone asked this question: I have passion for Oracle PL/SQL and learning new and advance techniques as well. Well my current Job does not require this a lot. How can I be in touch with Oracle PL/SQL advance topics and tricks as I am not able to code much My Reply: This is what you can do.  http://tryapexnow.com/ : You can create some sample application here. This is Oracle application express and you can create your own applications. Write as much code as you want. This is free tool provided by oracle corp. http://tryapexnow.com/ : You can review Oracle application Express by participating in the Early Adopter release. If you are working on earlier releases of Oracle, try 11g new features. Try this link. http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-efficient-coding.html Test you pl/sql knowledge here. http://apex.oracle.com/pls/otn/f?p=2853:10:2206418372587698::NO:10 :: More about pl/sql http://www.oracle.com/technology/tec...

Oracle Fusion: Oracle Enterprise Manager 11g for Middleware Management --  Oracle Enterprise Manager 11g for Middleware Management now support  Oracle Fusion Middleware 11g components (For Entire Fusion Family) -- You need not to switch between Grid Control, Fusion Middleware Control and the WebLogic -- You can now monitor the following targets. Oracle WebLogic Server Oracle SOA Suite Oracle HTTP Server Oracle Web Cache Oracle Identity Management Metadata Services repositories Oracle WebCenter Oracle Portal Oracle Business Intelligence Discoverer Oracle Forms Services Oracle Reports User Messaging Service Applications built using the Oracle Application Development Framework (ADF) -- You can now cusstomize Performance Summaries for Oracle Fusion Middleware 11g -- Support Workbench Support for Oracle Fusion Middleware 11g , Earlier this was available for Oracle database targets only.upload diagnostic data to Oracle Support with minimal effort in a short...

A strange problem: Oracle_home: 10.2.0.1 Oracle wallet connection is setup properly. sqlplus username/password@connectstring works fine. When we try to connect through wallet, Then it gives invalid username/password error. sqlplus /@connectstring gives error : ORA-01017: invalid username/password; logon denied Password entered was correct. as a workaround, use a tns connect string that is not 4, 8 or 12 bytes in length. Its unpublished bug in oracle. (4395883) Bugs fixed in the 10.2.0.2 Patch Set

Oracle WebLogic Server, --> a key component of Oracle Fusion Middleware --> offers a comprehensive solution for developing, integrating, and deploying enterprise applications, Web sites, portals, and Web services. Based on a scalable Java EE server --> Oracle WebLogic Server enables application deployment, business integration, and portals. --> Oracle WebLogic Server is designed for grid computing as well as full lifecycle support for SOA. Many of the Oracle Fusion Middleware components require the existence of Oracle WebLogic Server prior to installation. For Example if you have to install SOA suite. You need to have. 1. Oracle Database 2. RCU (Repository creation utility) to create the SOA schemas. 3. Web logic server. 4. Then you can install SOA WebLogic Server installation program :Software download location http://edelivery.oracle.com/ http://www.oracle.com/technology/software/products/ias/htdocs/wls_main.html There are the steps for installation of Oracle Web l...

This is the install process for R12 Oracle applications on LINUX. Assuming that the LINUX is ready with all the rpms and OS settings. I am doing a multiuser installation on LINUX. In order to prepare for a multi-user installation, you must first create an oracle user account and an applmgr user account. Both should be created with a default shell that is compatible with the Bourne shell. Log in as root to run Rapid Install. Then specify the oracle user as the Oracle OS user, and the applmgr user as the Apps OS user. Please complete all standard pre-reqs for LINUX install ( Like "/etc/sysctl.conf" for Shared memory and semaphors) Create Oracle user #useradd -u 1100 -g dba oraalpha #passwd oraalpha Changing password for user oraalpha. New UNIX password: BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: passwd: all authentication tokens updated successfully. # #useradd -u 1101 -g dba appalpha #passwd appalpha Changing password for user app...

Many of the Oracle Fusion Middleware components require schemas in a database prior to installation (Like SOA, Identity Management etc). RCU provides the flexibility to create custom schemas and tablespaces. If the tablespace does not exists, The urility will create the tablespaces. Download location : http://www.oracle.com/technology/software/products/middleware/htdocs/111110_fmw.html In this blog, I have demonstrated "How to run RCU. I have tested this on a windows env on a test system. cd /rcuHome/ On UNIX operating systems: ./rcu On Windows operating systems: rcu.bat First you will get the welcome screen for RCU Repository Creation Utility 1 Here you get option if you want to create or drop any existing schema. You need to provide the database details here. Please refer to Oracle Documentation for Character set information needed. Pre-req cheques, open_cursors required=350 and Processes required =500 in Database init.ora You are only allowed to...