Feed aggregator

Installation of oracle9i/10g on Linux & Solaris

Ayyappa Yelburgi - Mon, 2007-12-24 05:04
9/10g install on Linux/Solaris Install Oracle 9i Database on Linux RHEL AS 3the following lines can be added to the /etc/sysctl.conf file:kernel.shmmax = 2147483648kernel.shmmni = 128kernel.shmall = 2097152kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000In addition the following lines can be added to the /etc/security/limits.conf file:oracle soft nofile ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com76

Sql Scripts for knowing the transaction status

Ayyappa Yelburgi - Mon, 2007-12-24 05:00
select * from v$transaction;--All tranasactions + sid and usernameselect s.sid,s.username, t.start_time, t.used_ublk, t.used_urecfrom v$transaction t, v$session swhere t.ses_addr=s.saddr;--All tranasactions + sid and username + first 64 bytes of SQLselect s.sid,s.username, t.start_time, t.used_ublk, t.used_urec,sql.sql_textfrom v$transaction t, v$session s, v$sql sqlwhere t.ses_addr=s.saddrand ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com17

helping-optimizer-to-take-decision-10g.

Ayyappa Yelburgi - Mon, 2007-12-24 04:58
Give more knowledge to cost based optimizer about object statisticsand make it intelligent.. U remember Knowledge is Power - Aristotle-- Gather stats for a table. Auto sampling and auto number of histogram -- buckets, might not work in previous Oracle version.begindbms_stats.gather_table_stats('&OWNER','&TABLE_NAME',null,DBMS_STATS.AUTO_SAMPLE_SIZE -- put null or percentage for older oracle,falseayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6

helping-optimizer-to-take-decision-10g.

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

Query in DR....

Ayyappa Yelburgi - Mon, 2007-12-24 04:56
What is Right What is Wrong Found a DBA giving following commands at standby site to switchover while standby database was mounted.SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY*ERROR at line 1:ORA-16139: media recovery requiredSQL> recover managed standby database disconnect;Media recovery complete.SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6

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

Pages

Subscribe to Oracle FAQ aggregator