Re: TNS connection closed

This is going to sound ridiculous, but trust me (and look deep into my eyes... you are feeling very sleepy.....) : use the character-based management technique rather than this new-fangled (and ultimately unsatisfactory) GUI stuff they call OEM.

Hence: Start-Run cmd. Now set ORACLE_SID=name of Instance Then svrmgrl (conceivably sqlplus /nolog if you're doing this on a Client and not the server).
Connect internal/oracle (or whatever you've changed it to) -or better, conect sys/magic_password as sysdba
Startup (potentially startup pfile=xxxx if your init.ora is not in the default location)

To backup: Select * from v$tablespace;
Now, one at a time: alter tablespace blah begin backup - operating system copy - alter tablespace blah end backup - alter tablespace next_blah begin backup - os copy -... and so ad inifintum.

Once all that is working, time to knock up some batch scripts containing the same sorts of commands, and to dabble with AT to schedule the thing.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"CME Systems" <support_at_cmesys.demon.co.uk> wrote in message
news:972483660.24969.0.nnrp-04.c2de4217_at_news.demon.co.uk...


> All

>     I have re-built my database after a monumental pigs ear, thanks to

> everyone for your patience and help with the redo.log thing. I am trying

 to


> get to the stage of backing up the database so this is not repeated. I

 have


> set the database to the archivelog mode was attempting to set up the

> management server when it started whinning about TNS connection closed. I

> have re-booted and stopped services re-started services, had a cup of tea

> etc,etc. Can anyone give me a clue of :

> 1. How to get me able to communicate with the database again.

> 2. The best method of perfoming a backup should the unthinkable happen

 again


>

> I cannot access the database at all at the moment from the client or

 server.


> I am 'running' this on NT4 with oracle 8.1.6

>

> Thanks in advance

> Andy Lovegrove

> Oracle Idiot

>

>