Oracle em not working due to expired passwords

Ensure that ORACLE_HOME is set to the correct home

1. Stop the standalone dbconsole
on Unix
$ emctl stop dbconsole
on Windows
Stop the Windows Service Oracle<oracle_home_name>DBConsole
Or
Open a DOS Command Window and type
C> emctl stop dbconsole

2. Check that the standalone dbconsole is stopped
on Unix
$ emctl status dbconsole
on Windows
Check the status of the Windows Service Oracle<oracle_home_name>DBConsole
Or
Open a DOS Command Window and type
C> emctl status dbconsole

3. Connect to the database as a user with DBA privilege with SQL*Plus
and execute
SQL> alter user sysman identified by <new_password> ;

4. Check the new password
SQL> connect sysman/<new_password>[@database_alias]

5. Go to $ORACLE_HOME/host_sid/sysman/config
5.1 Save the file emoms.properties to emoms.properties.orig
5.2 Edit the file emoms.properties
a. Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Replace the encrypted value by the new password value
b. Search for the line:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
Replace TRUE by FALSE

6. Restart the standalone dbconsole
on Unix
$ emctl start dbconsole
on Windows
Start the Windows Service Oracle<oracle_home_name>DBConsole
Or
Open a DOS Command Window and type
C> emctl start dbconsole

7. Check that the password has been encrypted
Edit the file emoms.properties
7.1 Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted
7.2 Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE

Reinstall Grub

Boot your Helena live CD
* Open a terminal – Applications, Accessories, Terminal.
* Determine your normal system partition – `sudo fdisk -l` (That is a lowercase L)
* If you aren’t sure, run `df -Th`. Look for the correct disk size and ext3 or ext4 format.
* Mount your normal system partition:

sudo mount /dev/sdXY /mnt

- Example: sudo mount /dev/sda1 /mnt
- Note: substitue the correct partition: sda1, sdb5, etc.
- Note: GRUB 2 counts the first drive (X) as “0″, but the first partition (Y) as “1″

* Only if you have a separate boot partition:

sudo mount /dev/sdXY /mnt/boot

- with sdXY being your /boot partition designation.

* Reinstall GRUB 2:

sudo grub-install –root-directory=/mnt /dev/sdX

- Example: sudo grub-install –root-directory=/mnt /dev/sda
- Note: Substitute the correct device – sda, sdb, etc. Do ”not” specify a partition number.

* Unmount the partition:

sudo umount /mnt

* Reboot.

Reorder partition drive numbers in linux

Open a terminal and type

sudo fdisk -l

That’s a lowercase “L”. This will list storage devices in alphanumeric order. Look through the data reported and note the name of any devices that are listed out of numerical order.

To reorder the Linux drive partition numbers for device sdc, all we need to do is open a terminal…

  • type
    sudo fdisk /dev/sdc
  • then
    • press “x” to enter Expert Mode
    • press “f” to fix the drive order
    • press “i” to ignore the warning (if it shows)
    • press “w” to write changes to the disk
    • press “q” to  quit fdisk

 

Apache log rotation on Linux

A tool called logrotate can be used for rotating log files. It is a generic tool can can be configured to handle any log generated by any service.

The main configuration file of logrotate is /etc/logrotate.conf from where it picks up default setup.

It then reads service specific instructions from /etc/logrotate.d directory

The apache logrotate configuration is /etc/logrotate.d/httpd

/var/log/httpd/*log {
daily
rotate 7
compress
missingok
notifempty
sharedscripts
create 644 root root
postrotate
/sbin/service httpd reload > /dev/null 2>/dev/null || true
endscript
}

 

Apache case sensitivity

Migrating from a windows server to Linux?? Well, the most frustrating problem you’ll come up against is plenty of 404-File not found errors due to case-sensitive urls.

If you are using Apache then there is a tool just for this, Apache’s mod-speling module(BTW thats not a spelling mistake; thats how its named).

The module is installed by default in Apache 1.3 and later. All you have to do is add this directive to httpd.conf

CheckSpelling on