Below is the workaround steps
1. Startup database in mount mode
SQL> startup mount
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2078264 bytes
Variable Size 4160752072 bytes
Database Buffers 117440512 bytes
Redo Buffers 14696448 bytes
Database mounted.
2. Check the values for Undo related parameter
SQL> show parameter undo
Jaraswut's Blog
Some Experiences To Share.
Find
Tar Extract a Single File(s) From a Large Tarball
Tar Extract a Single File(s) From a Large Tarball
Extracting Specific Files
Extract a file called etc/default/sysstat from config.tar.gz tarball:
$ tar -ztvf config.tar.gz
$ tar -zxvf config.tar.gz etc/default/sysstat
$ tar -xvf {tarball.tar} {path/to/file}
Extracting Specific Files
Extract a file called etc/default/sysstat from config.tar.gz tarball:
$ tar -ztvf config.tar.gz
$ tar -zxvf config.tar.gz etc/default/sysstat
$ tar -xvf {tarball.tar} {path/to/file}
Posted by
Jaraswut
Simple Shell Script Backup & Restore
Simple Shell Script Backup
Simple Shell Script.
#!/bin/sh
####################################
#
# Backup to NFS mount script.
#
####################################
# What to backup.
backup_files="/home /var/spool/mail /etc /root /boot /opt"
# Where to backup to.
dest="/mnt/backup"
Simple Shell Script.
#!/bin/sh
####################################
#
# Backup to NFS mount script.
#
####################################
# What to backup.
backup_files="/home /var/spool/mail /etc /root /boot /opt"
# Where to backup to.
dest="/mnt/backup"
Posted by
Jaraswut
How to Mount CD-ROM in Linux
How to Mount CD-ROM in Linux
Finding out your CD/DVD names in Linux
hdc: VMware Virtual IDE CDROM Drive, ATAPI CD/DVD-ROM drive
hdc: ATAPI 1X DVD-ROM DVD-R-RAM CD-R/RW drive, 32kB Cache, UDMA(33)
Syntax to mount DVD / CDROM in Linux
The syntax is:
# mount -t iso9660 -o ro /dev/deviceName /path/to/mount/point
Finding out your CD/DVD names in Linux
hdc: VMware Virtual IDE CDROM Drive, ATAPI CD/DVD-ROM drive
hdc: ATAPI 1X DVD-ROM DVD-R-RAM CD-R/RW drive, 32kB Cache, UDMA(33)
Syntax to mount DVD / CDROM in Linux
The syntax is:
# mount -t iso9660 -o ro /dev/deviceName /path/to/mount/point
Posted by
Jaraswut
How to disable fsck at boot for a specific filesystem
How to disable fsck at boot for a specific filesystem
1. Edit /etc/fstab using your favorite text editor:
# vi /etc/fstab
2. Locate the line that contains the filesystem in question
and modify the last number in the row to '0', which disables fsck.
1. Edit /etc/fstab using your favorite text editor:
# vi /etc/fstab
2. Locate the line that contains the filesystem in question
and modify the last number in the row to '0', which disables fsck.
/dev/VolGroup/LogVol /mountpoint ext4 defaults 1 0
^ fsck disable
Posted by
Jaraswut
How to disable SSH login for the root user.
How to disable SSH login for the root user.
1. Edit ssh config file:
#vi /etc/ssh/sshd_config
2. Change this line:
#PermitRootLogin yes
Change from yes to no
3. Restart service sshd
#/etc/init.d/sshd restart
1. Edit ssh config file:
#vi /etc/ssh/sshd_config
2. Change this line:
#PermitRootLogin yes
Change from yes to no
3. Restart service sshd
#/etc/init.d/sshd restart
Posted by
Jaraswut
Forgotten root Password (Linux)
Forgotten root Password (Linux)
You can log in using single-user mode and create a new root password.
1. At the boot loader menu, use the arrow keys to highlight the installation
you want to edit and type [A] to enter into append mode.
2. You are presented with a prompt that looks similar to the following:
grub append> ro root=LABEL=/
3. Press the Spacebar once to add a blank space,
then add the word single to tell GRUB to boot into single-user Linux mode.
The result should look like the following:
ro root=LABEL=/ single
4. Press [Enter] and GRUB will boot single-user Linux mode.
After it finishes loading, you will be presented with a shell prompt similar to the following:
sh-2.05b#
5. You can now change the root password by typing
passwd root
6. Reboot by typing reboot at the prompt;
7. You can log in to root as you normally would.
You can log in using single-user mode and create a new root password.
1. At the boot loader menu, use the arrow keys to highlight the installation
you want to edit and type [A] to enter into append mode.
2. You are presented with a prompt that looks similar to the following:
grub append> ro root=LABEL=/
3. Press the Spacebar once to add a blank space,
then add the word single to tell GRUB to boot into single-user Linux mode.
The result should look like the following:
ro root=LABEL=/ single
4. Press [Enter] and GRUB will boot single-user Linux mode.
After it finishes loading, you will be presented with a shell prompt similar to the following:
sh-2.05b#
5. You can now change the root password by typing
passwd root
6. Reboot by typing reboot at the prompt;
7. You can log in to root as you normally would.
Posted by
Jaraswut