Rick’s Blog

I like to see passionate people perform no matter what the venue or outlet of their passionate manifestation is. Passionate dabs, programmers, writers, advertisers, designers or singers, it is all about communicating and connecting your passion to another person or mass populations. dabs express their passion in a artfully crafted and easily maintained schema and well tuned queries. Programmers connect with thousands by designing and coding applications that people want to use. Google or Ameritrade are two examples.

Prince is definitely passionate. He makes no apology for creating and sharing his vision. So when I was in Vegas for a conference I was excited to find club 3121 venue where I could get close to Prince’s live performance. The intensity and showmanship was exciting and helps me to connect with my inner techno-passions. I will be a better visionary, architect, DBA, programmer, communicator and leader because of this experience.

Once you find out how to connect with your own passion your work will become fun, easy, and inspiring. Explore other people who you consider passionate, then study the way they access, use and communicate that passion. Find out what works for you and incorporate those patterns of success into your routine.

Arrived in Vegas. Already seeing and speaking with some attendees. Looking forward to the new announcement from Charles Phillips.

Going to see Prince tonight! Standing room only crowd. Hope it is a high energy passionate performance!!! Ya, could it be anything else?

We made it!! DST is here and we are happy.

Sun Mar 11 01:59:58 EST 2007
Sun Mar 11 01:59:59 EST 2007
Sun Mar 11 03:00:00 EDT 2007
Sun Mar 11 03:00:02 EDT 2007

On a new install of Enterprise Manager 10.1 we would get random failures caused by the dbsnmp account getting locked(timed) due to failed login attempts exceeding the default profile’s setting of ten.

This is caused by the dbsnmp user connecting with the wrong password more than 10 times in a row which forces an account lockout. With the account locked out EM can’t connect to the database. The database is still up and fine.

To work around the problem I have created a new profile and assigned that profile to the dbsnmp user and unlocked the account as shown below.

SQL> create profile dbsnmp limit failed_login_attempts unlimited;

Profile created.

SQL> alter user dbsnmp profile dbsnmp;

User altered.

SQL> alter user dbsnmp account unlock;

User altered.

-Rick

Two of our DBA’s will be attending Collaborate ’07 this year. We will be focusing on the core RDBMS, RMAN, Streams, Data Guard and Oracle Fusion/Apps server. Wrap all that into Enterprise Management best practices and were ready to go.

I’m looking forward to meeting up with all my friends there and continue the geek-fest started at Oracle Open World. I’ll

Once again I will be sharing my room with some lucky attendee. I am staying at the Luxor Pyramid which is across the street from the convention. The room has two beds and internet access. If you are also attending Collaborate ’07, are a non-smoker, and would like to share a room let me know (paulr@onebetter.com).

At this point I am signed up for the following:

• Oracle Database 10g: Streams, Implementing Data Replication
• High Availability Using RMAN and Data Guard

I’ll post more information as I have it.

It is easy to see why I am so excited about Oracle. It just keeps getting better and better. Below is a snip from the press release. This will definately increase opportunities in the BI field. The Internet is fresh and new again!

Oracle Buys Enterprise Performance Management Leader Hyperion 12,000 companies use Hyperion software including 91 of the Fortune 100

http://www.oracle.com/corporate/press/2007_mar/hyperion.html

I had an agent install fail for some reason and could not get the agent to re-install. I had to start the installer (in GUI mode) and click on “Installed Products” and remove the oracle agent by selecting the agent home. Then I was able to re-run the install and it completed successfully.

One of the new features of 10g that we really like is Flashback Database. We had just enabled this feature on a development database and a few days later one of our developers reported that a table had been dropped accidentally. Wow, in the past this would have been a lot of work to recover the dropped table. With flashback database we were able to flashback the tablespace in three minutes (from request to completion). Now that is a really cool time saver.

You will still want to encourage your users to use common sense but flashback will make all our lives easier.

Here is an example implementation step to enable and use flashback.

shutdown immediate;
startup mount;
alter database flashback on;
select flashback_on from v$database — verify it
alter database open;
select flashback_on from v$database — verify it
create restore point before_upgrade;

If you need to restore:

shutdown immediate;
startup mount;
flashback database to restore point before_upgrade;

You can check the restore point with v$restore_point.

We will be writing more about flashback database and other oracle technologies in the future.

The enterprise manager installation can not use symbolic links for the repository directory. I ran into this problem while installing using the “Complete install” option on a single host. The fix was to use the full real path for the parent of the oracle homes.

The problem is that the Secure Certificate for the license server is expired. Simply change your clock (system date/time) to anytime between 9/17/2005 and 9/16/2006. Then start Elicit and click the registration button. In several seconds the license registration will complete and your all set. 

This is the software that I use to make windows tollerable. I have it automatically start Outlook and print out the Day View of the calendar at 5AM every weekday. That way when I come into work I have a quick overview of my day sitting at the printer. With this paper copy I can make notes and edits throughout the day and pass the paper to my secretary to make any updates or follow-up notes. This has to do with making your time more productive. You can get Automate Professional here 

PL/SQL code tester from TOAD. There online talking place is Quest Code Tester for Oracle Community

Welcome to my first post. I will post information on Oracle, IT, SOA, BPEL, application development and delivery as well as career and personal development.

If you have anything you would like to see here or just want to ask a question, please feel free to contact me. This posting will be replaced and updated when more information develops.

Read the rest of this entry »