Oracle MVA

Tales from a Jack of all trades

Enable archivelog through listener

with one comment

Suddenly I found myself migrating a database from 8.1.7 to on Windows (don’t ask πŸ˜‰ ). Migration steps were rather easy:

  • Set NLS_LANG to proper value
  • Create export of user (it was only one user)
  • Check privileges and tablespaces
  • Create new database (not in archivelog mode for performance reasons)
  • Create tablespaces
  • Create user and grant privileges
  • Import user
  • Enable archiving and schedule rman backup *ERROR!!!*

All of the sudden I found myself being able to create a database, being member of ORA_DBA privilege group, but not able to connect without the listener. This means that when you shutdown the database (before you can put it in mount phase) your connection is *gone*.

Now what !? I’m no Windows-man. Never have been, never will be.

After a cup of coffee is tried just close the database (alter database close), enable archivelog mode (alter database archivelog) and restart the Windows service. Jeez this is dirty, but it works. Time to have a colleague find out what’s wrong with the domain user I used πŸ˜‰


Written by Jacco H. Landlust

September 17, 2009 at 7:31 pm

Posted in RDBMS

One Response

Subscribe to comments with RSS.

  1. Hi Jacco,
    Don’t know the error you got, but if the 10-database resides on the same box as the 8-version, it looks like the switch between the environments went wrong. Sometimes it’s not enough to use only the ORACLE_HOME. Oracle8 on Windows depended heavily on the registry. An ‘Oracle Home Selector’ was used in the old days ….


    September 22, 2009 at 4:19 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: