[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

[Spacewalk-list] Oracle XE archive log mode



Hi

I have now spent some time to enable the above but no luck. I have tried
so many websites and they all say the same with no success:

The instructions i have are:

login into db with sqlplus:
sqlplus 'sys/Bl3rtsi31@//localhost/XE as sysdba'
shutdown or shutdown immediate

This shuts down the server. Next the instructions says,

start a new instance:
I am sure you do that by:
sqlplus /nolog
then execute
startup mount

this is where things go wrong.
it always says:
SQL> startup mount
ORA-12162: TNS:net service name is incorrectly specified

How do i get oraclexe to start the db in mount so i can execute:

ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;


to enable archivelog mode.

Thanks

Kobus



LOVEFiLM UK Limited is a company registered in England and Wales.
Registered Number: 06528297.
Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom.

This e-mail is confidential to the ordinary user of the e-mail address to which it was
addressed. If you have received it in error, please delete it from your system and notify
the sender immediately.

This email message has been delivered safely and archived online by Mimecast.
For more information please visit http://www.mimecast.co.uk



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]