OraNA :: Oracle News Aggregator

I have over 100+ saved sessions in PuTTY running on Windows and was looking for a way to move those session to Linux.

Here’s a demo on how to move those PuTTY sessions.

First, download pwin2lin.pl on Linux from https://code.google.com/p/pwin2lin/

Next, install PuTTY on Linux from http://pkgs. (more...)

Practice makes perfect, but it does not have to be difficult. Please don’t short yourself by not trying to understand what is going on.

This is my third RAC install and I got tired of doing it the hard manual way; hence, decided to script what I can.

ASM will (more...)

Download

Instant Client Package – Basic Lite
Instant Client Package – SQL*Plus

http://www.oracle.com/technetwork/topics/winsoft-085727.html

Modify hosts file

C:\Windows\System32\drivers\etc>more hosts
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP  (more...)

[oracle@rac01 ~]$ tail /etc/oratab

# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
 (more...)

Live, Learn and Share is the signature from a friend that I used to work with – Chau Vu

Today, I learned something new because I was shared something by a colleague – Jing Han

If you know part of filename for what you are looking for but don’t know (more...)

Before, I worked for organization that frowned upon database jobs and only uses cron job.
Now, it’s just the opposite and I get to learn about dbms_scheduler job.

Create job to run PLSQL_BLOCK every 5 minutes at: 21,22,23 (24 hour format)

LAX:(MDINH@db01)> @createjob

SYSDATE
-------------------
2013-05-04 12:29:55

LAX:(MDINH@db01)> begin
  2    (more...)

Do you get annoyed at having to answer the questions all the time for patching?

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for  (more...)

CRS and Cluster, what’s the difference and which one should I use for start and stop?

CRS is Cluster Ready Service and used to manage HAS (High Availability Services)

Cluster is where the application runs on.

Stop CRS is local to the node and will shutdown local HAS – crsctl (more...)

Please take a look at Menu (all the way to the right) and you will find:

Linux
Patches and Upgrades

Information is good, but how fast can you find it?

Changed from Pages to Menu.

Where should I put my ASM disks?

-----------------------------------------------------------------------
CrystalDiskMark 3.0.2 x64 (C) 2007-2013 hiyohiyo
                           Crystal Dew World : http://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 byte/s [SATA/300 = 300,000,000 byte/s]

           Sequential Read :   194.352 MB/s
          Sequential Write :   194.577 MB/s
         Random Read 512KB :    72.506  (more...)