sap instance not running

[Former Member]

Dear Expert team,

I have refresh our QAS sever with PRD server , after refreshing , Oracle is starting but SAP Instance is not running

I have  start lisner , Oracle as givne below , but sap instance is not running .

QL> startup

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

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size                  2190320 bytes

Variable Size            2348811280 bytes

Database Buffers         2315255808 bytes

Redo Buffers               10530816 bytes

Database mounted.

Database opened.

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL>

sapqas:qasadm 40> startsap

Checking QAS Database

Database is not available via R3trans

-------------------------------------------

Trying to start QAS database ...

Log file: /home/qasadm/startdb.log

/usr/sap/QAS/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

please send the tracefile /home/qasadm/startsap.trc to support

sapqas:qasadm 41> pwd

sapqas:qasadm 44> R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'QAS'"

R3trans finished (0012).

sapqas:qasadm 45>

No any file is generating in 

/usr/sap/QAS/DVEBMGS00/work/

Please find the alert.QAS.log  some lines.

Thanks

Alert_log_file.txt.zip

[kaus19d]

Hi Pooja,

its obvious that the process not completed, so the new table name was supposed to take as per the QAS SID. Check the BRTOOLS might not also run. Generally, Terminating with error code 12,  in transport or whatever in these kind of scenarios 8 or 12 means simply stating that some object is missing. I believe that before doing the refresh you had a backup of your QAS System. Since, it seems that your procedure was not complete, Could we know what exact steps did you take for doing this Refresh Job??

Thanks,

Kaushik