Feed aggregator

Query in DR....

Ayyu's Blog - Mon, 2007-12-24 04:56
Categories: DBA Blogs

How to create Databas in 2 node RAC ..?

Ayyappa Yelburgi - Mon, 2007-12-24 04:55
Database creation in RAC environment( 2 instances). can not rely on dbca always CREATE PARAMETER FILE AND PLACE IT IN SHARED LOCATION (O:\TEST\INITTEST.ORA shared location here ) AS FOLLOWING SO THAT BOTH RAC INSTANCES CAN SHARE IT. point to this pfile/spfile from individual instance home/dbs. # START OF INITTEST.ORA *.aq_tm_processes=1*.test1.background_dump_dest='D:\Oracle\admin\test1\bdump'*.ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com8

How to create Databas in 2 node RAC ..?

Ayyu's Blog - Mon, 2007-12-24 04:55
Categories: DBA Blogs

Way to get Query execution plan in Oracle10g

Ayyappa Yelburgi - Mon, 2007-12-24 04:24
traditional method before 10gselect * from v$sql where address='&ADDRESS' and hash_value=&HASH_VALUE;10g select * from v$sql where sql_id='&SQL_ID';select * from v$sqlstats where sql_id='&SQL_ID';select * from dba_hist_sqlstat where sql_id='&SQL_ID';select * from table(DBMS_XPLAN.DISPLAY_CURSOR('&SQL_ID', NULL, 'ALL'));select * from table(DBMS_XPLAN.DISPLAY_AWR('&SQL_ID',&PLAN_HASH,NULL,'ALL'));ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com24

Agile PLM 9.2.2.1 – Part II – Database Node Installation

Aviad Elbaz - Mon, 2007-12-24 01:51
Following my last post about Agile PLM 9.2.2.1 – Part I, in this post I’ll show, step by step, how to install Agile PLM 9.2.2.1 system.

The latest version of Agile PLM is 9.2.2.2, but it's too much new to install it for production..

I installed the Agile PLM 9.2.2.1 on 2 nodes configuration:

1) Agiledb – Oracle Database server Node
C:\ drive – OS only
D:\ drive – Database 10g software and Datafiles

2) Agileapp – Agile Application + IIS + Oracle AS + Agile File Manager Node
C:\ drive – OS only
D:\ drive – Agile 9.2.2.1 applications + Oracle AS
E:\ drive – File Vault (managed by the File Manager)

** Both servers installed with Windows 2003 Server OS.

This post will describe all phases of database node installation, and next post I’ll describe the application node installation.

The Agile Database node installation composed from the following steps:
- Complete all database installation pre requisites
- Oracle Database 10.2.0.1 installation
- Oracle Datbase companion installation
- Agile Database creation
- Listener configuration

Database Node Installation - Pre Requisites

1) If server is DHCP configured you should setup a loopback (10g installation requirements)
a. Control panel -> Add hardware



b. Choose: Yes, I have already connected the hardware


c. Choose: Add a new hardware device (the last item on list)


d. Choose: Install the hardware that I manually select from a list


e. Choose: Network adapters


f. Choose at the left side: Microsoft at right side choose: Microsoft loopback adapter



g. Edit the server host file at c:\windows\system32\driver\etc\hosts
Add the following line:
10.10.10.10 agiledb.domain agiledb


h. Navigate to network connections: Start -> settings -> Network Connections
i. Right Click on Local Area Connection – Microsoft Loopback Adapter -> properties


ii. Select TCP/IP -> properties


iii. Edit the ip address to 10.10.10.10
iv. Edit the subnet mask to 255.255.255.0


2) Restart the server


Oracle Database 10.2.0.1 installation

1) Run database installer – setup.exe (from database directory)
2) Select Basic installation – Standard Edition
a. Oracle Home Location: d:\oracle\product\10.2.0\db_1
b. Uncheck the Create Starter Database


3) Review prerequisite checks


4) Click on Install…


5) Exit



Database Companion Installation

1) Run the installer – setup.exe (from companion directory)


2) Select Oracle Database 10g Products 10.2.0.1.0


3) Specify Home details:
a. Name: OraDb10g_home1
b. Path: D:\oracle\product\10.2.0\db_1


3) Review prerequisite checks


4) Install…


5) Exit


Agile Database Creation

1) Copy the “Platform” directory from Agile Disk2 directory to Agile Disk1 directory to the setup.exe level


2) Run [Disk1]:\windows\setup.exe


3) Accept license agreement
4) Enter the license key and user name.


5) Select : Database Server only


6) Enter the location to install the selected Agile 9.2.2.1 components:
D:\agile\agile9221


7) Select Oracle 10g Database Server


8) Install


9) Destination folder for database customization files: d:\Agile9Tmp


10) Select “Medium” Database size
For more information regarding each possibility - small, medium, large... - read the Capacity Planning Guide


11) Select the previous installed oracle home


12) Oracle SID: agile9


13) Enter passwords for Sys and System and user name and password for Agile schema.

14) Click some next’s…




15) Agile installation will create the database


16) Done



Configure Database Listener

1) Navigate to: Start Menu -> Programs -> Oracle - OraDb10g_home1 -> Configuration and Migration Tools -> Net Manager


2) Create new Listener, Name: Listener


3) Select Database Services from the drop down list
a. Click on Add database
b. Global Database Name: Agile9
c. Oracle Home Directory: d:\oracle\product\10.2.0\db_1
d. SID: agile9


4) File -> Save Network Configuration
5) Restart the Listener
a. Lsnrctl stop
b. Lsnrctl start


That’s all for the Agile Database node.
Next post I’ll show the Agile 9.2.2.1 Application node installation.

For more information:
Capacity Planning Guide
OracleAgile Database Installation Guide

You are welcome to leave a comment.
Aviad
Categories: APPS Blogs

any-longer-getting-ddl

Ayyappa Yelburgi - Sun, 2007-12-23 04:06
--1 Get DDL of the object:declareclb CLOB; pos INTEGER:=1; amt INTEGER; len INTEGER; txt VARCHAR2(4000);beginclb := dbms_metadata.get_ddl ('$OBJ_TYPE','$OBJ_NAME','$OWNER');len := LENGTH(clb);LOOPamt := nvl(INSTR (clb, chr(10), pos),len) - pos;IF amt>0 THEN txt := NVL(SUBSTR (clb, pos, amt),' '); ELSE txt:=''; END IF;pos := pos + amt + 1;DBMS_OUTPUT.put_line (SUBSTR(txt,1,250));EXIT WHEN pos>=lenayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6

any-longer-getting-ddl

Ayyu's Blog - Sun, 2007-12-23 04:06
Categories: DBA Blogs

Typical-index-maintenance-tasks-9i10g

Ayyappa Yelburgi - Sun, 2007-12-23 04:03
--1 Move index from one tablespace to anotheralter index &OWNER.&INDEX_NAME rebuild tablespace &NEW_TS_NAME;--2 Moving index partition from one tablespace to anotheralter index &OWNER.&INDEX_NAMErebuild partition &IND_PART_NAME tablespace &NEW_TS_NAME;--3 Moving all index subpartitions from one tablespace to anotheralter index &OWNER.&INDEX_NAMErebuild subpartition &IND_SUBPART_NAME tablespace &ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com31

Typical-index-maintenance-tasks-9i10g

Ayyu's Blog - Sun, 2007-12-23 04:03
Categories: DBA Blogs

keeping-eye-on-sessions

Ayyappa Yelburgi - Sun, 2007-12-23 04:01
--Long operationsselect sid,username usern,serial#,opname,target,sofar,totalwork tot_work,units,time_remaining remaning,elapsed_seconds elapsed,last_update_time last_timefrom v&session_longops --where sid=73order by last_update_time desc;--All active sessionsselect * from v&session where status='ACTIVE'--and sid in (37,43)order by sid;--Find session's sid or process id by it's sid or process ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6

keeping-eye-on-sessions

Ayyu's Blog - Sun, 2007-12-23 04:01
Categories: DBA Blogs

moving-tablespartitions-9i-onwards

Ayyappa Yelburgi - Sun, 2007-12-23 04:00
-1 Move table from one tablespace to another-- (check for unusable indexes after that).alter table $OWNER.$TABLE_NAME move tablespace $NEW_TS_NAME;--2 Move table partition from one tablespace to another-- (check for unusable indexes and partitoned indexes after that).alter table $OWNER.$TABLE_NAMEmove partition $TAB_PART_NAME tablespace $NEW_TS_NAME;--3 Move table subpartition from one tablespaceayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com20

moving-tablespartitions-9i-onwards

Ayyu's Blog - Sun, 2007-12-23 04:00
Categories: DBA Blogs

Solaris 10 on Dell PowerEdge 1950 and 2950

Hampus Linden - Thu, 2007-12-20 11:58
I probably get an email every couple a weeks about this one, not sure why.
E-mails regarding something in Solaris not working on Dell PowerEdge 9th gen servers.

For any device driver related issues with Solaris on x86, the first resource to check if you run in to trouble is the Sun HCL, the 'hardware compatability list'.
Solaris 10 works fine on most Dell boxes, but some need NIC or HBA drivers.

For a Dell 2950 that tells us that Solaris works, from release 11/06 upwards, it also tells us to download the ethernet driver here and the MegaRAID SAS driver here.

NB, the Sun HCL does not mention the new 'III' series 9-gen server yet. I would guess they are working on as Sun and Dell recently partenered to provide better Solaris support. The PERC6 card may need some new drivers.

Agile PLM 9.2.2.1 - Part I

Aviad Elbaz - Thu, 2007-12-20 02:27
In May this year, Oracle has acquired Agile, a leading provider of Product Lifecycle Management (PLM) software solutions.

In this post I will explain about the various components of Agile PLM system, and the following posts will be dedicated to Agile PLM installation.

The components of Agile PLM application are:
1) Agile Database
2) Agile Application Server
3) Agile File Manager
4) Agile Web Proxies
These components should be installed in the above order.

Agile Database
Used to hold all Agile data.
It is recommended to install the database and application server on separated machines.

Agile Application Server
The Agile Application Server can be run on Oracle Application Server 10g or BEA WebLogic Server.
The Application Server is the main component of the Agile system, all services and business logic reside on it.
The Agile application deployed on the Application Server.
All users (Java/Web clients) connect to the Application Server in 2 possible ways:
- Directly
- Indirectly, via Wev proxy Server.

Agile File Manager
The File Manager manages all Agile files in the file system (File Vault).
The File Manager runs on Tomcat.

Agile Web Proxies Server
The Agile web client allows connection to both internal and external users.
Agile web client uses Microsoft IIS (Internet Information Services) or Apache web server.
The Agile web client connects to an Agile Application Server the same way like other Agile Application Server clients.



Next post I will show, step by step, how to install Agile PLM 9.2.21 on two nodes configuration.

Aviad
Categories: APPS Blogs

Need to Kill j000 process to shutdown the database after upgrade from 8.1.7.4 to 9.2.0.8.

Madhu Thatamsetty - Wed, 2007-12-19 22:20
This is a common problem after the upgrade. One important point to remember is to disable all the schedules for dbms jobs before kicking off the upgrade and enable the schedule after the uprade is over. Alternatively job_queue_processes parameter can be set to '0'.You see following symptoms in the alert log.-- Clip --Active call for process 21244 user 'oracle' program 'oracle@hostname (J000)'Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com1

Oracle EBS R12 beta exam are you ready

Fadi Hasweh - Wed, 2007-12-19 03:18
I received the following email from oracle certification program
“Oracle University is pleased to announce the availability of the following new Oracle E-Business Suite (R12) certification exam in beta version:
Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238]
This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified Professional certification.
By participating in this beta exam, you have the opportunity to provide the Oracle Certification program with feedback about exam content which is integral to the process of exam development. We depend on the contributions of experienced professionals and developers as we continually improve exam content and maintain the value of Oracle certifications.

Beta exam period runs:
January 03 – April 04, 2008
These beta periods are subject to change, please check the exam pages for the most up-to-date information


Good luck with your exams
fadi

Regular Expressions: REGEXP_COUNT (New SQL Snippets Tutorial)

Joe Fuda - Sun, 2007-12-16 14:00
Introduced in Oracle 11g the REGEXP_COUNT function greatly simplifies counting the number of times a pattern appears inside a string. The following examples demonstrate how to use REGEXP_COUNT with some simple patterns. For versions prior to 11g alternative logic that provides similar functionality is also presented.
...

Mac OSX, Bootcamp and a Missing Hash Key

Duncan Mein - Sun, 2007-12-16 12:58
I bought a Mac Book Pro about 8 months ago as my main business Laptop. Coupled with a copy of Parallels, I built my Oracle Server (Database and Apps Server) on a Windows VM environment which left Mac OSX free for Development using SQL Developer, Dreamweaver etc

A couple of weeks back I decided to upgrade to OSX Leopard and install windows natively using Bootcamp to utilise both core's on the CPU and all 3 Gig of memory. All well and good until i tried to use the Hask key (Alt + 3 in OSX) when working on some APEX templates. After much research on the web, it appears that most OSX key mappings are installed when using bootcamp but in order to print the hash (#) symbol, you must use Ctrl + Alt + 3

Simple when you know how

Pages

Subscribe to Oracle FAQ aggregator