Oracle 10g step by step installation video on windows platform

I've just found a good tutorial video on how to install Oracle 10g step by step on windows platform from youtube.com. There are 4 videos altogether. These 4 video are a a basic oracle installation good for oracle newbie. Have a look for yourself.


Step by step guide on installation oracle 10g database part I



Step by step guide on installation oracle 10g database part II





Step by step guide on installation oracle 10g database part III




Step by step guide on installation oracle 10g database part IV



Reference:youtube.com

Read More

Testing Oracle 10g RAC Scalability

I have just found a good video on youtube about Oracle 10g RAC Scalability, This video is very informative. If you are considering of deploying Oracle RAC on your organization this is a cool one to watch. Below is the detail I grab from youtube video description:

Oracle Real Application Clusters (RAC) offer businesses the ability to create an environment where more than one database server, or node, can be setup to manage an Oracle database. Organizations often face multiple challenges when implementing RAC and maintaining RAC configurations, including:

Determining how many database servers are needed for sustained optimal
performance in a cluster
Defining the proper testing methodology of a cluster configuration for load testing, scalability and availability
This Webcast will provide you with:

A proven methodology for determining the most optimal configuration for your Oracle RAC environment.
A real-world scenario in which Quest's solutions were leveraged for Oracle RAC to conduct diagnostic and benchmark tests on Oracle Real Application Clusters.

and the video is here you don't have to leave to youtube to watch it, just click on the play icon.

Video Title: Testing Oracle 10g RAC Scalability.
Time: 35.49 minutes.

Read More

Ora Tip: How much did you assign your memory for oracle sga and pga?

If you want to know how much does your oracle database taking up memory for SGA and PGA just login to your oracle database with the following command on the command prompt

if you can access to the server physically or remotely
sqlplus "/ as sysdba"

otherwise use this command

sqlplus "sys@ora_service as sysdba"

SQL>show SGA
you would see something like the following lines but difference on number.

Total System Global Area 209235968 bytes
Fixed Size 1298920 bytes
Variable Size 109055512 bytes
Database Buffers 96468992 bytes
Redo Buffers 2412544 bytes

this is how your system Global Area taking your memory space every time your database is running.

to see what is your SGA size just run the following command

SQL>show parameter pga

and you would get the folloing result

pga_aggregate_target big integer 75M

this is how much your pga consume your memory.

Read More

TNS-12535: TNS:operation timed out

There might be sometime that when you try to connect to Oracle Server and you get the error "TNS-12535: TNS:operation timed out". It seem that the server does not exist or the listener does not start or both of them. The first thing you need to have a look is
the tnsnames.ora which could be found at
- $ORACLE_HOME/network/admin for unix like OS ie. every distribute of Linux, Solaris etc.
- ..\oracle\product\10.2.0\ for Windows Platform

in this tnsnames.ora will look like this

ora_service_name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORA_Server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA_SID)
)
)

there are 2 things you need to have a look there.

The first one is to check if your Ora_SID is correct, if you don't know please contact your dba admin and ask for it.

The Second thing you need to take a look at is the HOST part host/ip parth (HOST=....) this is where your oracle server is.

If both Ora_SID and HOST are correct then try to ping the server to see if you can reach the server (there might be the case that the network admin turn the ping port of for security reason though, in this case you are behind firewall).

To make sure if you are really behind the firewall try telnet the server with this syntax
telnet server_IP 1521 ( or whatever your Oracle listening port is). If you get the following error

Connecting To your server_ipd...Could not open connection to the host, on port 1521:
Connect failed

then 90% you are behind firewall, please contact your network administrator to turn the firewall on port 1521 on.

Read More

ORA-00600: internal error code, arguments: [19004],

If you ever come across the error code "ORA-00600: internal error code, arguments: [19004], [], []...." while running query ralated to any table, view, index
here is the solution for it

login to your oracle database using pl/sql tool

run the below command on the command prompt

1. in case of error on querying table

ANALYZE TABLE table_name delete statistics;

2. in case of error on querying view

put the command above with related tables in the view. i.e run analyze tables for each table that form that view.

reference:http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4005.htm

Read More

Oracle RAC Test on VMWare Linux + openfiler SAN/NAS storage

For people who don't want to spend much money on SAN storage just for the purpose of testing Oracle RAC feature.
One of the option you can do is installing VMWare on your computer and set up 2 Linux virtual servers on it. You will also need another virtual server to set up as openfiler to act as SAN storage. The hardware requirement you need to have are 3 GB of memory, 50 GB of hard disk (excluding your host OS space).
For more information on how to do this you can drop in to http://www.oracledba.ca/ there are step by step + image guide for you.

Read More

Runing Oracle on Linux + VMWare

There are many website talked about oracle installation on Linux which is running on VMWare.
There are many comments I come across mentioned that this must be for the testing or developing purpose only.

I'd myself rather think differently. If you have computer with huge enough resources you can set it up as your virtual servers and running on your network along with physical servers. It depend of the art of tuning your VMWare , Linux, Oracle, with new oracle improved functionality it could be easier to manage. I myself, used to train my 10+ clients and had them connected to my laptop (at the time 2GB Memory), runing VMWare with Linux and Oracle installed, it worked just fine.

The thing is, it's on the art of put the right tools/machines for the right task. With well configuration of your Oracle, VMWare, Linux plus your host resources, your virtual servers will work like a charm.

Read More

FIX EXP-00008: ORACLE error 604 encountered while exporting full database

if you had the below error (Error 1) while exporting full database
login as sys user and execute the following sql command at sqlplus prompt

GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;

and if after running the above sql command and you got the an error (Error 2).
login as sys user and then execute the file
$ORACLE_HOME/rdbms/admin/owminst.plb to validated LT_EXPORT_PKG .
at sqlplus prompt
>@$ORACLE_HOME/rdbms/admin/owminst.plb
ie.
>@$D:\oracle\ora90\rdbms\admin\rdbms\admin\owminst.plb


Error 1
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_i
nfo_exp

Error 2
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp

Read More

Oracle RAC Test on VMWare Linux + openfiler SAN/NAS storage

For some of you who don't want to spend much money on SAN storage just for the purpose of testing Oracle RAC feature.
One of the option you can do is install VMWare to set up Linux on it. And you need openfiler to act as SAN storage. for more information on how to do this you can drop in to http://www.oracledba.ca/ there are step by step + image guide for you.

Read More

Oracle Database 11g:The Top New Features for DBAs and Developers

Database Replay


Explore Database Replay, the new tool that captures SQL statements and lets you replay them at will.


Partitioning


Learn about Referential, Internal, and Virtual Column partitioning; new sub-partitioning options; and more.

Schema Management


Add columns with a default value easily and explore invisible indexes, virtual columns, and read only tables.


SQL Performance Analyzer


Accurately assess the impact of rewriting of SQL statements and get suggested improvements.


SQL Access Advisor


Get advice about optimal table design based on actual use of the table, not just data.


Transaction Management


Get an introduction to Flashback Data Archive and explore EM's Log Miner interface.

SQL Plan Management


Learn how to baseline and compare optimizer plans and then choose the best one.


SQL Repair Advisor


Explore how to use SQL Repair Advisor to identify problematic SQL statements and gather diagnostic information.


Manageability Features


Explore automatic memory management, multicolumn statistics, online patching, and more features.


PL/SQL: Coding


Avoid unneeded invalidation during changes, track null exceptions, interchange cursors, and more.

Security

Learn about Tablespace Encryption, case-sensitive passwords, data masking, and other features.


Result Cache

Don't go to the database if data has not changed. Use result cache instead, both in SQL and PL/SQL.


Resiliency


Explore Automatic Health Monitor, Automatic Diagnostic Repository, and other new resiliency features.


SQL Operations: Pivot and Unpivot
Make creating pivot operation on tables a breeze using new keywords.


ASM Improvements


Learn about variable AU sizing, rolling upgrades, and node affinity in RAC environments, among other things.


SecureFiles


Explore next-generation LOBs: LOB encryption, compression, de-duplication, and asynchronicity.

Data Guard Improvements


Query the physical standby database in real time without shutting down recovery, just for starters.


PL/SQL: Performance

Explore in-lining of code, native compilation without C compiler, PLS timer, use of simple integer, and more.

RMAN Improvements


Explore Data Recovery Advisor, Virtual Private Catalog, parallel backup of the same datafile, and other features.


Other...

COPY command, Export/Imports, Data Pump improvements, PHP Connection Pooling, and more.


more information click here

Read More

Proxy List

Here are the proxy server with it port ( Transparent proxy)
195.175.37.70:8080
201.245.28.74:8080
201.28.44.10:3128
201.72.179.3:3128
202.106.62.117:80
202.155.4.114:3128
202.63.233.8:8080
203.160.1.45:553
203.199.198.232:3128
209.149.181.5:80
209.202.137.35:80
210.212.95.99:8080
211.140.192.98:8080
222.124.11.218:3128
58.211.234.194:3128
58.22.97.55:8080
58.26.9.158:3128
59.145.72.6:8080
60.173.7.17:80
60.248.186.136:3128
60.52.117.19:3128
61.184.196.162:8080
61.220.150.2:3128
61.47.19.211:8080
71.230.108.90:3128
80.36.58.71:8080
81.10.57.186:3128
81.7.87.242:3128
83.238.44.49:8080
84.19.177.62:8080
85.199.0.2:3128
86.107.212.10:3128
87.118.106.214:3128
87.197.51.90:3128
84.19.176.62:8080
62.173.116.73:80
62.75.159.159:8080
72.29.108.81:80
64.34.199.36:80
82.225.163.158:3128
64.200.180.169:80
66.118.220.27:80
61.91.30.62:3128
200.211.233.131:3128 WORK
203.160.1.146:554
203.160.1.146:553
219.93.182.99:3128
75.63.143.140:3128
200.149.1.100:80
200.149.1.100:3128
200.211.233.132:3128
219.93.83.126:8080
222.124.142.89:6588
64.79.160.177:80
63.109.247.193:80
80.58.205.61:80
59.120.36.85:3128
201.34.32.44:3128
201.2.35.6:8080
200.175.156.173:3128
200.206.131.82:3128
200.171.124.197:3128
200.161.3.60:3128
69.60.127.20:80
210.212.95.100:8080
83.133.119.38:8080
85.185.16.126:8080
220.225.18.147:8080
212.122.243.2:3128
140.110.17.218:3128
200.254.105.131:3128
82.207.44.14:3128
201.23.203.233:3128
201.90.65.5:3128
200.193.144.138:80
193.220.51.5:8080
195.112.212.186:3128
218.7.48.22:8080
202.82.116.26:3128
193.255.143.6:8080
193.69.167.132:8080
195.8.178.100:8080
200.87.6.19:3128
61.135.153.116:8080
202.146.91.196:8080
195.175.37.71:8080
195.175.37.8:8080
195.175.37.6:8080
66.98.238.8:3128
195.175.37.71:80
65.243.68.184:80
62.150.76.250:80
195.175.37.8:80
64.56.191.191:80
64.56.191.222:80
64.56.191.221:80
60.173.7.17:3128
219.235.232.240:3128
164.58.221.238:3128
200.241.108.198:3128
200.141.141.193:8080




200.88.125.9:8008
72.29.108.81:80
213.16.20.140:3128
200.103.18.29:3128
64.34.199.36:80
84.19.177.62:8080
202.163.200.153:80
84.19.176.62:8080
66.54.171.210:80
202.155.4.114:3128
201.36.165.130:3128
201.17.147.71:3128
203.160.1.146:553
213.163.31.253:3128
203.198.69.125:3128
203.198.69.124:3128
203.198.69.123:3128
219.87.129.180:3128
64.200.180.169:80
203.26.206.131:553
81.8.231.130:3128
201.12.137.221:3128
69.244.185.39:8217
203.26.206.130:553
84.17.228.113:8080
69.88.144.163:80
81.7.87.242:3128
64.79.160.177:80
80.58.205.61:80
59.120.36.85:3128
219.87.129.186:3128
217.156.89.185:8080
213.4.106.85:8080
210.211.217.78:3128
203.185.44.56:8080
203.154.86.170:8080
200.206.131.82:3128
200.181.55.100:8080
200.171.124.197:3128
200.161.3.60:3128
200.101.52.50:8080
69.60.127.20:80
209.190.240.18:80
65.243.68.184:80
64.56.191.222:80
64.56.191.221:80
64.56.191.191:80
211.48.62.46:80
203.116.61.164:80
200.96.11.121:80
200.118.2.164:80
195.175.37.8:80
195.175.37.71:80
195.175.37.70:80
144.140.22.190:80
193.63.43.10:8080
61.47.19.215:8080
200.87.120.46:8080
220.227.171.147:8080
195.175.37.8:8080
202.146.91.196:8080
195.175.37.70:8080
195.175.37.71:8080
61.135.153.116:8080
202.52.242.69:8080
159.148.29.62:8080
222.124.206.43:8080
212.92.18.12:8080
203.116.61.164:8080
195.175.37.6:8080
63.118.235.195:8080
202.28.186.3:8080
202.69.140.10:8080
210.212.95.103:8080
61.81.185.103:8080
222.124.193.82:8080
222.255.69.42:8080
201.25.52.10:8080
61.19.25.163:3128
220.227.141.153:3128
221.226.124.123:3128
58.216.235.242:3128
200.216.119.138:3128
66.98.238.8:3128
200.210.115.100:3128
61.146.114.237:3128
200.253.116.3:3128
210.212.156.14:3128
61.19.23.226:3128
200.203.94.49:3128
201.57.66.2:3128
210.72.99.19:3128

Read More

Proxy List

195.175.37.70:8080
201.245.28.74:8080
201.28.44.10:3128
201.72.179.3:3128
202.106.62.117:80
202.155.4.114:3128
202.63.233.8:8080
203.160.1.45:553
203.199.198.232:3128
209.149.181.5:80
209.202.137.35:80
210.212.95.99:8080
211.140.192.98:8080
222.124.11.218:3128
58.211.234.194:3128
58.22.97.55:8080
58.26.9.158:3128
59.145.72.6:8080
60.173.7.17:80
60.248.186.136:3128
60.52.117.19:3128
61.184.196.162:8080
61.220.150.2:3128
61.47.19.211:8080
71.230.108.90:3128
80.36.58.71:8080
81.10.57.186:3128
81.7.87.242:3128
83.238.44.49:8080
84.19.177.62:8080
85.199.0.2:3128
86.107.212.10:3128
87.118.106.214:3128
87.197.51.90:3128
84.19.176.62:8080
62.173.116.73:80
62.75.159.159:8080
72.29.108.81:80
64.34.199.36:80
82.225.163.158:3128
64.200.180.169:80
66.118.220.27:80
61.91.30.62:3128
200.211.233.131:3128 WORK
203.160.1.146:554
203.160.1.146:553
219.93.182.99:3128
75.63.143.140:3128
200.149.1.100:80
200.149.1.100:3128
200.211.233.132:3128
219.93.83.126:8080
222.124.142.89:6588
64.79.160.177:80
63.109.247.193:80
80.58.205.61:80
59.120.36.85:3128
201.34.32.44:3128
201.2.35.6:8080
200.175.156.173:3128
200.206.131.82:3128
200.171.124.197:3128
200.161.3.60:3128
69.60.127.20:80
210.212.95.100:8080
83.133.119.38:8080
85.185.16.126:8080
220.225.18.147:8080
212.122.243.2:3128
140.110.17.218:3128
200.254.105.131:3128
82.207.44.14:3128
201.23.203.233:3128
201.90.65.5:3128
200.193.144.138:80
193.220.51.5:8080
195.112.212.186:3128
218.7.48.22:8080
202.82.116.26:3128
193.255.143.6:8080
193.69.167.132:8080
195.8.178.100:8080
200.87.6.19:3128
61.135.153.116:8080
202.146.91.196:8080
195.175.37.71:8080
195.175.37.8:8080
195.175.37.6:8080
66.98.238.8:3128
195.175.37.71:80
65.243.68.184:80
62.150.76.250:80
195.175.37.8:80
64.56.191.191:80
64.56.191.222:80
64.56.191.221:80
60.173.7.17:3128
219.235.232.240:3128
164.58.221.238:3128
200.241.108.198:3128
200.141.141.193:8080




200.88.125.9:8008
72.29.108.81:80
213.16.20.140:3128
200.103.18.29:3128
64.34.199.36:80
84.19.177.62:8080
202.163.200.153:80
84.19.176.62:8080
66.54.171.210:80
202.155.4.114:3128
201.36.165.130:3128
201.17.147.71:3128
203.160.1.146:553
213.163.31.253:3128
203.198.69.125:3128
203.198.69.124:3128
203.198.69.123:3128
219.87.129.180:3128
64.200.180.169:80
203.26.206.131:553
81.8.231.130:3128
201.12.137.221:3128
69.244.185.39:8217
203.26.206.130:553
84.17.228.113:8080
69.88.144.163:80
81.7.87.242:3128
64.79.160.177:80
80.58.205.61:80
59.120.36.85:3128
219.87.129.186:3128
217.156.89.185:8080
213.4.106.85:8080
210.211.217.78:3128
203.185.44.56:8080
203.154.86.170:8080
200.206.131.82:3128
200.181.55.100:8080
200.171.124.197:3128
200.161.3.60:3128
200.101.52.50:8080
69.60.127.20:80
209.190.240.18:80
65.243.68.184:80
64.56.191.222:80
64.56.191.221:80
64.56.191.191:80
211.48.62.46:80
203.116.61.164:80
200.96.11.121:80
200.118.2.164:80
195.175.37.8:80
195.175.37.71:80
195.175.37.70:80
144.140.22.190:80
193.63.43.10:8080
61.47.19.215:8080
200.87.120.46:8080
220.227.171.147:8080
195.175.37.8:8080
202.146.91.196:8080
195.175.37.70:8080
195.175.37.71:8080
61.135.153.116:8080
202.52.242.69:8080
159.148.29.62:8080
222.124.206.43:8080
212.92.18.12:8080
203.116.61.164:8080
195.175.37.6:8080
63.118.235.195:8080
202.28.186.3:8080
202.69.140.10:8080
210.212.95.103:8080
61.81.185.103:8080
222.124.193.82:8080
222.255.69.42:8080
201.25.52.10:8080
61.19.25.163:3128
220.227.141.153:3128
221.226.124.123:3128
58.216.235.242:3128
200.216.119.138:3128
66.98.238.8:3128
200.210.115.100:3128
61.146.114.237:3128
200.253.116.3:3128
210.212.156.14:3128
61.19.23.226:3128
200.203.94.49:3128
201.57.66.2:3128
210.72.99.19:3128

Read More

Oracle Default Port

When you first installed oracle, if you haven't changed the port number, the default listening port is 1521. But for the security issue, if you are serious about it, this should be changed to something else. There would be one more step for client setup, you need to specify what port number to connect to your oracle dba server. Which maybe a bit annoying, so most people would leave it as a default option.

Read More

Trojan port list

This summary is not available. Please click here to view the post.

Read More

Simple Oracle Auditing

Oracle's RDBMS is a functionally rich product and there are a number of auditing alternatives available to the reader. Because auditing Oracle is such a huge subject, doing all of it justice would take an entire book, so this paper will cover the basics of why, when and how to conduct an audit. It will also use a couple of good example cases to illustrate how useful Oracle audit can be to an organization.....
read more here http://www.securityfocus.com/infocus/1689

Read More