Question Re: sap instance not running in Additional Q&A

sap instance not running

Former Member — Wed, 05 Oct 2016 09:01:48 GMT

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

Re: sap instance not running

kaus19d — Wed, 05 Oct 2016 09:20:06 GMT

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

Re: sap instance not running

Isaias_SAP — Wed, 05 Oct 2016 19:55:04 GMT

Hello Pooja,

Execute "R3trans -d" again.

Then open the "trans.log" file that will be created at the same folder where you have executed R3trans.

Information on that log file might help you / your Oracle team to fix the issue .

Regards,

Isaías

Re: sap instance not running

Reagan — Wed, 05 Oct 2016 21:42:50 GMT

What authentication mechanism are you using? OPS$ or SSFS?

Check if it is properly set up and if not you may fix it first.

Finally run R3trans -d -w /dev/tty and supply the output.

Re: sap instance not running

Former Member — Fri, 07 Oct 2016 02:17:45 GMT

Dear Isaías ,

I have checked the trans.log ,no any user is locked .

sapqas:qasadm 26> 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 27>

Please find the trans log

sapqas:qasadm 24> more trans.log

a55y0C4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 07.10.2016 - 07:33:20

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Fri Oct 7 07:33:20 2016 214 0.000214

4 ETW000 [ dev trc,00000] db_con_init called 23 0.000237

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 197 0.000434

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 37 0.000471

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 24 0.000495

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 50 0.000545

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 36163 0.036708

4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 36 0.036744

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 55 0.036799

4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.327)

4 ETW000 389 0.037188

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 45 0.037233

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 110 0.037343

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 59 0.037402

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so4 ETW000

4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.037500

4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 48 0.037548

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000 101 0.037649

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.037681

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 32 0.037713

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.037739

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeo

4 ETW000 167 0.037906

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 34 0.037940

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 26 0.037966

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 35 0.038001

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.038025

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeou

4 ETW000 57 0.038082

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.038107

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000 61 0.038168

a55y0CdBtrans.log (30%)d@a55y0Ca55y0C4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 43 0.038211

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 40 0.038251

4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 47 0.038298

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 83 0.038381

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 7803 0.046184

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 234 0.046418

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 95 0.046513

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000 358 0.046871

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000 38 0.046909

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 25 0.046934

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 35 0.046969

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 34 0.047003

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 144 0.047147

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 102 0.047249

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 66 0.047315

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000 195 0.047510

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000 38 0.047548

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.047572

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 35 0.047607

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 34 0.047641

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 85 0.047726

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 98 0.047824

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 66 0.047890

4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]

4 ETW000 156 0.048046

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not f

4 ETW000 67 0.048113

a55y0CdBtrans.log (60%)d@a55y0C...skipping...

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 07.10.2016 - 07:33:20

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Fri Oct 7 07:33:20 2016 214 0.000214

4 ETW000 [ dev trc,00000] db_con_init called 23 0.000237

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 197 0.000434

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 37 0.000471

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 24 0.000495

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 50 0.000545

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 36163 0.036708

4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 36 0.036744

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 55 0.036799

4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.327)

4 ETW000 389 0.037188

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 45 0.037233

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 110 0.037343

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 59 0.037402

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.037451

4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.037500

4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 48 0.037548

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000 101 0.037649

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.037681

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 32 0.037713

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.037739

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeo

4 ETW000 167 0.037906

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 34 0.037940

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 26 0.037966

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 35 0.038001

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.038025

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeou

4 ETW000 57 0.038082

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.038107

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000 61 0.038168

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 43 0.038211

a55y0CdBtrans.log (30%)d@a55y0Ca55y0C4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 40 0.038251

4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 47 0.038298

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 83 0.038381

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 7803 0.046184

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 234 0.046418

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 95 0.046513

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000 358 0.046871

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000 38 0.046909

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 25 0.046934

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 35 0.046969

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 34 0.047003

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 144 0.047147

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 102 0.047249

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 66 0.047315

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000 195 0.047510

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000 38 0.047548

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 24 0.047572

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 35 0.047607

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 34 0.047641

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000 85 0.047726

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" opened for read [rsecssfs.c 2359]

4 ETW000 98 0.047824

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/QAS/SYS/global/security/rsecssfs/key/SSFS_QAS.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000 66 0.047890

4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]

4 ETW000 156 0.048046

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not f

4 ETW000 67 0.048113

4 ETW000 [ dev trc,00000] read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAU

4 ETW000 45 0.048158

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 33 0.048191

4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='720')

4 ETW000 855 0.049046

4 ETW000 [ dev trc,00000] Register application info. 383 0.049429

4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 291112, UNICODE[2])

4 ETW000 115 0.049544

4 ETW000 [ dev trc,00000] Installed Oracle client patches: 59 0.049603

a55y0CdBtrans.log (66%)d@a55y0Ca55y0C4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

a55y0CdBtrans.log (67%)d@a55y0Ca55y0C4 ETW000 42 0.049645

4 ETW000 [ dev trc,00000] # Patch Description: Created on 2 Jan 2012, 04:56:08 hrs PST8PDT 43 0.049688

4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 51 0.049739

4 ETW000 [ dev trc,00000] Default connection: tnsname ='QAS' 34 0.049773

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000 58 0.049831

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 8081 0.057912

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=600000000239f058) 181 0.058093

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=60000000023a0318) 40 0.058133

4 ETW000 [ dev trc,00000] NLS env. settings: lang=0041004D00450052004900430041004E 216 0.058349

4 ETW000 [ dev trc,00000] terr=0041004D00450052004900430041 48 0.058397

4 ETW000 [ dev trc,00000] char=00550054004600310036 43 0.058440

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000 46 0.058486

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 32 0.058518

4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@QAS on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])

4 ETW000 58 0.058576

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=60000000023a0238) 102 0.058678

4 ETW000 [ dev trc,00000] Allocating server context handle 31 0.058709

4 ETW000 [ dev trc,00000] Attaching to database server QAS (con=0, svchp=60000000023a0238, srvhp=60000000023a35c0)

4 ETW000 67 0.058776

4 ETW000 [ dev trc,00000] Assigning server context 60000000023a35c0 to service context 60000000023a0238

4 ETW000 55222 0.113998

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=6000000002409f70) 120 0.114118

4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=6000000002409f70 39 0.114157

4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=6000000002409f70 44 0.114201

4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=60000000023a0238, srv=60000000023a35c0, usr=6000000002409f70)

4 ETW000 452 0.114653

4 ETW000 [ dev trc,00000] Fri Oct 7 07:33:21 2016 1014796 1.129449

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 39 1.129488

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 242 1.129730

4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 85 1.129815

4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 44 1.129859

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 42 1.129901

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 33 1.129934

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 123 1.130057

4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 45 1.130102

4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 51 1.130153

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 105 1.130258

4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 38 1.130296

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 61 1.130357

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 33 1.130390

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 34 1.130424

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 70 1.130494

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 44 1.130538

4 ETW000 [ dev trc,00000] -> 'OCI_102, 11.2.0.3.0, V1, default build' 36 1.130574

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

a55y0CdBtrans.log: ENDd@a55y0Ca55y0Cd@sapqas:qasadm 25>

sapqas:qasadm 25>

Re: sap instance not running

kaus19d — Fri, 07 Oct 2016 05:06:01 GMT

Check whether once again you need to generate the PFILE from your SPFILE.

Thanks,

Kaushik

Re: sap instance not running

Reagan — Fri, 07 Oct 2016 10:10:12 GMT


4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                  39  1.129488
4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:              242  1.129730
4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied

Have you seen this error?

Again, read my first answer.