You are currently browsing the Rick’s Blog weblog archives for September, 2007.

Sync passwords from one database to another

Here is a simple way to syncronize schema passwords from one Oracle database to another. On the source database run the following sqlplus command: SQL> select ‘alter user ‘ || username || ‘ identified by values ”’||  password ||”’;’from dba_users where username in (‘GMADMIN’,’GM_0′,’GM_0_REPORT’,’GM_0_STATS’); That will produce the following output which you can run on [...]

Posted by Rick on 22 Sep 2007 at 4:00 am under Oracle | Link

Best call center solution

In our survey of top call-centers 24-7 INtouch is rated number one. Give Travis Bailey a call and tell him “Rick sent me”. Check out their site at here or their blog here.

Posted by Rick on 20 Sep 2007 at 5:00 pm under Uncategorized | Link

PRKC-1044

I ran into this issue on one of our RAC clusters. The error is:The user “oracle” does not have user equivalence setup on nodes. Please setup the user equivalence before proceeding. PRKC-1044 : Failed to check remote command execution setup for node dbserver-010 using shells /usr/local/bin/ssh and /usr/bin/rsh dbserver-010: Connection refused. The fix was to [...]

Posted by Rick on 01 Sep 2007 at 11:24 am under Oracle | Link