Re: Newbie has TNS listener problem

IKerr. wrote:

> Another quick question: In a while I am going to have to do a machine
> reinstall: what is the best way to create a backup of my db

Your usual backup would be sufficient... :-^

  and designer
> repository/er diagrams,

Make an application export from Designer itself, and a user export of the repository owner.
so that I can get the db back up and running again
> with minimum of fuss, and considering the hassle in resurrecting the db this
> time what config files should I also backup, init.ora, listener.ora,
> tnsnames.ora - what else ?
>

No need to backup that - maybe print for reference. You will be doing a new install, so this is a new configuration.

After (re-)createion of the db, simply import the repository owner export. You should be able to run designer as usual. If not - reinstall a repository, and import the application export. This is the fallback scenario.

-- 
Regards, Frank van Bortel