Oracle XTTS Restore Step Failed : Error in executing xttstartupnomount.sql

Hi,

When I run Restore step for Oracle XTTS V4, i got ”  Error in executing xttstartupnomount.sql ” absurd error.

 

If you want to learn NEW Oracle XTTS V4 Cross platform database migration utility, you can read following article.

 

Error was taken in this Restore step.

 

[DEVECI]/backup/v4ttsTarget  $>   $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore
============================================================
trace file is /backup/v4ttsTarget/restore_Oct8_Tue_11_15_30_701//Oct8_Tue_11_15_30_701_.log
=============================================================

--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.

Total System Global Area 8.5516E+10 bytes
Fixed Size 2262656 bytes
Variable Size 1.4764E+10 bytes
Database Buffers 7.0599E+10 bytes
Redo Buffers 151117824 bytes

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Error:
------
Error in executing xttstartupnomount.sql
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[DEVECI]/backup/v4ttsTarget $

 

 

To solve this problem, You should remove remote_os_authent, background_dump_dest and user_dump_dest parameter in the parameter file (Pfile or SPFile), then Restart database.

 

SQL> alter system reset remote_os_authent scope=spfile;

System altered.

SQL> alter system reset background_dump_dest scope=spfile;

System altered.

SQL> alter system reset user_dump_dest scope=spfile;

System altered.

SQL>

 

After database Restart, try Run Restore step again. Problem will be solved.

 

 

 

 

nohup $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore &
============================================================
trace file is /backup/v4ttsTarget/restore_Oct8_Tue_23_37_02_565//Oct8_Tue_23_37_02_565_.log
=============================================================

--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------

--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------

[MehmetSalihTarget]/backup/v4ttsTarget $


Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.