R3trans -d gives a return code 0012 2EETW169 no connect possible after a server restart
trans-log-file.txttnsnames.txtlistener-file.txtHi,
We are unable to re-start our server after a planned shutdown for maintenance. R3 trans -d gives the following error :
DEV:devadm 11> R3trans -d
This is R3trans version 6.24 (release 721 - 19.10.16 - 20:16:07).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'DEV'"
R3trans finished (0012).
DEV:devadm 12>
For starters I have checked the entries in the tnsnames.ora and listener.ora files ,everything seems to be in order .
Re-started the listener service.
$ORACLE_HOME and $ORACLE_SID seems to set alright .
Tried to shut down oracle from the sql prompt and re-start, no luck.
# su - oradev
DEV:oradev 1> sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Oct 15 15:17:02 2019
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> shutdown
ORA-01012: not logged on
SQL> shutdown immediate
ORA-01012: not logged on
SQL> startup
ORA-01031: insufficient privileges
SQL>
Unable to run basic sql queries/commands:
e.g.,
SQL> SELECT * FROM v$version;
SP2-0640: Not connected
SQL>
AIX version : 6.1
Following are the o/p's of env/sapcontrol and the parameters in the instance profile
DEV:oradev 14> env
TERM=ansi
AUTHSTATE=files
SHELL=/bin/csh
HOME=/oracle/DEV
USER=oradev
PATH=/oracle/DEV/102_64/bin:.:/oracle/DEV:/usr/sap/DEV/SYS/exe/run:/usr/bin:/etc
:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java5/jre/bin:/usr/java5/bin
TZ=GMT0BST
LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
CLCMD_PASSTHRU=1
LOGNAME=oradev
LOGIN=oradev
SAPSYSTEMNAME=DEV
DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=DEV
dbs_ora_schema=SAPSR3
ORACLE_SID=DEV
DB_SID=DEV
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/DEV/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/DEV
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/DEV/SYS/exe/run:/oracle/DEV/102_64/lib
DEV:oradev 15> sapcontrol -nr 00 -function GetEnvironment
15.10.2019 15:34:21
GetEnvironment
OK
lines
LOGNAME=devadm
HOME=/home/devadm
SHELL=/bin/csh
TERM=vt100
PATH=/oracle/DEV/102_64/bin:/oracle/DEV/102_64/jdk/jre/bin:/home/devadm:/usr/sap
/DEV/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/devadm/bin:/usr/bin/X11:
/sbin:.
TZ=GMT0BST
LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
CLCMD_PASSTHRU=1
USER=devadm
SAPSYSTEMNAME=DEV
DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run
JAVA_HOME=/oracle/DEV/102_64/jdk/jre
IBM_JAVA_OPTIONS=-Xmx256M
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=DEV
dbs_ora_schema=SAPSR3
ORACLE_SID=DEV
DB_SID=DEV
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/DEV/SYS/profile/oracle
ORACLE_HOME=/oracle/DEV/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/DEV
MAIL=/var/spool/mail/devadm
MAILMSG=[YOU HAVE NEW MAIL]
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/sap/DEV/DVEBMGS00/exe:/usr/lib:/lib:/usr/sap/DEV/SYS/exe/run:/oracl
e/client/10x_64/instantclient
DEV:oradev 23> more DEV_DVEBMGS00_DEV
#.******************************************************************************
************************************************
#.*
*
#.* Instance profile DEV_DVEBMGS00_DEV
*
#.*
*
#.* Version = 000008
*
#.* Generated by user = CON_BASIS
*
#.* Generated on = 13.07.2018 , 15:35:49
*
#.*
*
#.******************************************************************************
************************************************
#parameter created by: CON_BASIS 13.07.2018 15:04:24
login/create_sso2_ticket = 2
#parameter created by: CON_BASIS 12.07.2018 16:12:13
icm/server_port_1 = PROT=SMTP,PORT=25000
#parameter created by: CON_BASIS 12.07.2018 16:11:26
is/SMTP/virt_host_0 = *:25000;
SAPGLOBALHOST = DEV
changed: CON_BASIS 12.07.2018 16:10:42
changed: CON_BASIS 13.07.2018 15:04:55
changed: CON_BASIS 13.07.2018 15:05:27
icm/host_name_full = DEV.lincpen.com
SAPSYSTEMNAME = DEV
SAPSYSTEM = 00
INSTANCE_NAME = DVEBMGS00
DIR_CT_RUN = $(DIR_EXE_ROOT)/run
DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
login/accept_sso2_ticket = 1
PHYS_MEMSIZE = 512
exe/saposcol = $(DIR_CT_RUN)/saposcol
rdisp/wp_no_dia = 4
rdisp/wp_no_btc = 1
exe/icmbnd = $(DIR_CT_RUN)/icmbnd
icm/server_port_0 = PROT=HTTP,PORT=80$$
#-----------------------------------------------------------------------
# SAP Messaging Service parameters are set in the DEFAULT.PFL
#-----------------------------------------------------------------------
dbms_type=ORA
dbs_ora_tnsname=DEV
dbs_ora_schema=SAPSR3
ORACLE_SID=DEV
DB_SID=DEV
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/DEV/SYS/profile/oracle
ORACLE_HOME=/oracle/DEV/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/DEV
MAIL=/var/spool/mail/devadm
MAILMSG=[YOU HAVE NEW MAIL]
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
e/client/10x_64/instantclient
ms/server_port_0 = PROT=HTTP,PORT=81$$
rdisp/wp_no_enq = 1
rdisp/wp_no_vb = 1
rdisp/wp_no_vb2 = 1
rdisp/wp_no_spo = 1
#---------------------------------------------------------------------
#Values proposed by SAP for shared memory pool sizes
#---------------------------------------------------------------------
ipc/shm_psize_10 = 154000000
ipc/shm_psize_14 = 0
ipc/shm_psize_18 = 0
ipc/shm_psize_19 = 0
ipc/shm_psize_30 = -10
ipc/shm_psize_40 = 488000000
ipc/shm_psize_41 = 0
ipc/shm_psize_51 = -10
ipc/shm_psize_52 = -10
ipc/shm_psize_54 = -10
ipc/shm_psize_55 = -10
ipc/shm_psize_57 = -10
ipc/shm_psize_58 = -10
Attaching the following logs/files :
1) trans.log
2) listener.ora file
3) tnsnames.ora file
Please suggest the approach we should follow in troubleshooting this issue.