July 2013
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

Categories

July 2013
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

Oracle DB startup Scripts

Starting oracle listener $ lsnrctl start

Start the database $ dbstart

Starting oracle Enterprise manager $ emctl start dbconsole

Shutting down the database $ dbshut

Stopping the listener $ lsnrctl stop

Stopping oracle Enterprise manager $ emctl stop dbconsole

Starts sqlplus without logging in to a database # su ­ […]

Oracle Schema Creation

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes.

$ sqlplus /nolog

SQL> connect / as sysdba […]

tips in linux

mount -t iso9660 -o loop file.iso /mnt # Mount a CD image

# mount -t ext3 -o loop file.img /mnt # Mount an image with ext3 fs

# mount -o loop file.iso /mnt # extract an iso image to mnt

Remount a device without unmounting it. # mount -o remount,ro /

Copy the raw […]

How to get the Disk informationhttp://rmohan.com/wp-admin/post-new.phps in linux

# hdparm -I /dev/sda —— information about the IDE/ATA disk (Linux) / disk performance # fdisk /dev/sda6 —— Display and manipulate the partition table # smartctl -a /dev/sda1 — Display the disk SMART info # diskinfo -v /dev/ad2 —- information about disk (sector/size) FreeBSD # dmidecode ——- dmidecode is a tool for dumping a computer’s […]