BRtools BR0613E

[former_member264831]

Hello,

I try to upgrade my Oracle DB from 11 to 12.

First I changed the DB user from ora<SID> to oracle according to note

1915317 - Migration des Software-Eigentümers zu 'oracle'

and

1983457 - Klonen von Oracle Homes unter Unix und Linux

It seems to work. R3trans -d return "R3trans finished (0000)." and the SAP System runs.

ThanI tried to upgrade der BRtools acording to note 1598594 - BR*Tools-Konfiguration für Oracle-Installationen unter "oracle"-User

an error appear when I try the command

sles13:hr1adm 80> brconnect -u / -f check

BR0801I BRCONNECT 7.40 (16)

BR0805I Start of BRCONNECT processing: cerjhmbo.chk 2015-09-10 15:07:44

BR0484I BRCONNECT log file: /oracle/HR1/sapcheck/cerjhmbo.chk

BR0613E Database instance HR1 is shut down

BR0806I End of BRCONNECT processing: cerjhmbo.chk 2015-09-10 15:07:44

BR0280I BRCONNECT time stamp: 2015-09-10 15:07:44

BR0804I BRCONNECT terminated with errors

Can anybody help me, please

Best regards

A. Moore

[former_member264831 · Accepted solution]

Hello everbody,

no it works.

The solution is that I change the ORACLE_HOME env. for sidadm from /oracle/SID/12102 (the normal folder) to /oracle/SID/121 (the symbolic link) .

Thanks everybody for you help and tips.

Best regards

A. Moore

[Brindavan_M]

Hello ,

while checking the error log that show with SIDADM, try to login ORASID and then execute brtools...

I am able to see the database is shutdown..check that as well.

Thanks,

Brindavan

[Former Member]

Hi A.Moore,

Re-check and adjust below steps.

Summary from SAP Note 1598594:

1. Set File Permissions for SAP BR*Tools
   As 'root', set permissions of SAP BR*Tools that are installed in /usr/sap/<SAPSID>/SYS/exe/run as follows:
   [root]# chown oracle:oinstall brarchive brbackup brconnect brrecover brrestore brspace
   [root]# chmod 6774 brarchive brbackup brconnect brrecover brrestore brspace
2. Create Directory sapprof
   As 'root', create 'sapprof' profile directory /oracle/<DBSID>/sapprof and
   move init<DBSID>.sap from <ORACLE_HOME>/dbs to 'sapprof' directory.
   [root]# mkdir -p <SAPDATA_HOME>/sapprof
   [root]# mv <ORACLE_HOME>/dbs/init<DBSID>.sap <SAPDATA_HOME>/sapprof
   [root]# mv <ORACLE_HOME>/dbs/init<DBSID>.ora <SAPDATA_HOME>/sapprof
   [root]# chown -R oracle:oinstall <SAPDATA_HOME>/sapprof
3. Create Database Profile
   As 'oracle', create a new database profile init<DBSID>.ora in the $ORACLE_HOME/dbs directory that contains only the "spfile" parameter.
   Sample entry for release 11.2:
   spfile=/oracle/<DBSID>/112_64/dbs/spfile<DBSID>.ora
   Sample entry for release 10.2:
   spfile=/oracle/<DBSID>/102_64/dbs/spfile<DBSID>.ora
4. Create a new database user 'OPS$ORACLE'
   SQL> connect / as sysdba
   SQL> create user ops$oracle identified externally;
   SQL> grant sapdba to ops$oracle;
5. Verify Configuration
   Verify that SAP BR*Tools are working correctly with the new file ownership and can connect to the database
   As '<sapsid>adm', you can test as follows:
   OS> brconnect -u / -f check
   OS> brbackup -u / -q

Thanks and Regards,,

Pradeep Chanda

[former_member264831]

Hello Pradeep Chanda,

I executed the commands you mentioned.

Unfortunately the same error appeared

sles13:hr1adm 55> brconnect -u / -f check

BR0801I BRCONNECT 7.40 (16)

BR0805I Start of BRCONNECT processing: cerjhwmp.chk 2015-09-10 17:05:11

BR0484I BRCONNECT log file: /oracle/HR1/sapcheck/cerjhwmp.chk

BR0613E Database instance HR1 is shut down

BR0806I End of BRCONNECT processing: cerjhwmp.chk 2015-09-10 17:05:11

BR0280I BRCONNECT time stamp: 2015-09-10 17:05:11

BR0804I BRCONNECT terminated with errors

best regards

A. Moore

[indra_gunalan]

Hello,

Please try to run with trace to see more information about the error

brconnect -u / -f check -TRC 11

Regards,

Indra

[former_member264831]

Hello Indra,

here the whole output:

sles13:hr1adm 58> brconnect -u / -f check -TRC 11

BR0801I BRCONNECT 7.40 (16)

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0248I BR_TRACE: level 0, function main entry with 'brconnect -u / -f check -TRC 11'

BR0200I BR_TRACE: location BrEnvProcess-1, Environment of BRCONNECT:

'TERM=xterm'

'HOME=/home/hr1adm'

'SHELL=/bin/csh'

'USER=hr1adm'

'LOGNAME=hr1adm'

'PATH=/oracle/HR1/112_64/bin:.:/home/hr1adm:/usr/sap/HR1/SYS/exe/run:/home/hr1adm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/gnome/bin:/usr/local/bin'

'HOSTTYPE=x86_64'

'VENDOR=suse'

'OSTYPE=linux'

'MACHTYPE=x86_64-suse-linux'

'SHLVL=1'

'PWD=/home/hr1adm'

'GROUP=sapsys'

'HOST=sles13'

'CSHEDIT=emacs'

'MAIL=/var/spool/mail/hr1adm'

'CPU=x86_64'

'HOSTNAME=sles13.bb.bbmsg'

'INPUTRC=/etc/inputrc'

'LESS=-M -I'

'LESSOPEN=lessopen.sh %s'

'LESSCLOSE=lessclose.sh %s %s'

'LESS_ADVANCED_PREPROCESSOR=no'

'LESSKEY=/etc/lesskey.bin'

'PAGER=less'

'MORE=-sl'

'MINICOM=-c on'

'MANPATH=/usr/local/man:/usr/share/man:/opt/gnome/share/man'

'INFODIR=/usr/local/info:/usr/share/info:/usr/info'

'INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info'

'XKEYSYMDB=/usr/share/X11/XKeysymDB'

'XNLSPATH=/usr/share/X11/nls'

'COLORTERM=1'

'JAVA_BINDIR=/usr/lib64/jvm/java/bin'

'JAVA_ROOT=/usr/lib64/jvm/java'

'JAVA_HOME=/usr/lib64/jvm/java'

'JRE_HOME=/usr/lib64/jvm/java/jre'

'JDK_HOME=/usr/lib64/jvm/java'

'SDK_HOME=/usr/lib64/jvm/java'

'CVS_RSH=ssh'

'XCURSOR_THEME=Industrial'

'QT_HOME_DIR=/usr/share/desktop-data'

'LANG=en_US.UTF-8'

'ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal'

'PKG_CONFIG_PATH=/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig'

'GNOME2_PATH=/usr/local:/opt/gnome:/usr'

'FROM_HEADER='

'NNTPSERVER=news'

'WINDOWMANAGER=/usr/bin/gnome'

'PYTHONSTARTUP=/etc/pythonstart'

'XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/gnome/share:/opt/kde3/share:/usr/share/gnome/help'

'XDG_CONFIG_DIRS=/etc/xdg'

'G_BROKEN_FILENAMES=1'

'G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252'

'ENV=/etc/bash.bashrc'

'CSHRCREAD=true'

'LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:'

'LS_OPTIONS=-N --color=tty -T 0'

'SAPSYSTEMNAME=HR1'

'DIR_LIBRARY=/usr/sap/HR1/SYS/exe/run'

'RSEC_SSFS_DATAPATH=/usr/sap/HR1/SYS/global/security/rsecssfs/data'

'RSEC_SSFS_KEYPATH=/usr/sap/HR1/SYS/global/security/rsecssfs/key'

'rsdb_ssfs_connect=1'

'THREAD=NOPS'

'dbms_type=ORA'

'dbs_ora_tnsname=HR1'

'dbs_ora_schema=SAPR3'

'ORACLE_SID=HR1'

'DB_SID=HR1'

'ORACLE_BASE=/oracle'

'TNS_ADMIN=/oracle/HR1/112_64/network/admin'

'ORACLE_HOME=/oracle/HR1/112_64'

'NLS_LANG=AMERICAN_AMERICA.WE8DEC'

'SAPDATA_HOME=/oracle/HR1'

'DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt'

'DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt'

BR0805I Start of BRCONNECT processing: cerjlgls.chk 2015-09-11 09:36:16

BR0484I BRCONNECT log file: /oracle/HR1/sapcheck/cerjlgls.chk

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0644I BR_TRACE: location BrDbConnect-3, SQL statement:

'CONNECT /'

BR0300I BR_TRACE: SQL code: -1034, number of processed rows: 0

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0644I BR_TRACE: location BrDbConnect-21, SQL statement:

'COMMIT RELEASE'

BR0300I BR_TRACE: SQL code: -1012, number of processed rows: 0

BR0200I BR_TRACE: location BrPipeOpen-1, command line:

'( /oracle/HR1/112_64/bin/sqlplus /nolog ) < /dev/null 2>&1'

BR0200I BR_TRACE: location ora_vers_get-18, SQLPLUS output from pipe:

'^'

'SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 11 09:36:16 2015^'

'^'

'Copyright (c) 1982, 2010, Oracle.  All rights reserved.^'

'^'

'SQL> '

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0644I BR_TRACE: location db_connect-3, SQL statement:

'CONNECT /'

BR0300I BR_TRACE: SQL code: -1034, number of processed rows: 0

BR0613E Database instance HR1 is shut down

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0644I BR_TRACE: location db_connect-3, SQL statement:

'CONNECT /'

BR0300I BR_TRACE: SQL code: -1034, number of processed rows: 0

BR0806I End of BRCONNECT processing: cerjlgls.chk 2015-09-11 09:36:16

BR0280I BRCONNECT time stamp: 2015-09-11 09:36:16

BR0804I BRCONNECT terminated with errors

sles13:hr1adm 59>

[indra_gunalan]

Hello,

you have wrong ORACLE_HOME on hr1adm user Currently it is set to'ORACLE_HOME=/oracle/HR1/112_64'.

You should adjust it to /oracle/HR1/12102

Regards,

Indra

[Former Member]

There's one more SAP note to consider;

Did you try a search with keyword BR0613E ?

[former_member264831]

Hello,

yes but I can`t find a solution that works for me.

Best regards

A. Moore

[Former Member]

I was thinking of the environment variable ORACLE_SID for your user hr1adm.

It seems to be HR1; correct?

Are you on Oracle RAC?

Is Oracle running on the same host from where you run brconnect?

If you try 'ps -ef | grep oracle', what is the output?

Processes like oracleHR1, or something different, like oracleHR1xyz, or nothing at all?

regards

[former_member264831]

Hello

the ORACLE_SID is HR1

sles13:hr1adm 60> env | grep -i ora

PATH=/oracle/HR1/112_64/bin:.:/home/hr1adm:/usr/sap/HR1/SYS/exe/run:/home/hr1adm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/gnome/bin:/usr/local/bin

LD_LIBRARY_PATH=/usr/sap/HR1/SYS/exe/run:/oracle/client/12x/instantclient

dbms_type=ORA

dbs_ora_tnsname=HR1

dbs_ora_schema=SAPR3

ORACLE_SID=HR1

ORACLE_BASE=/oracle

TNS_ADMIN=/oracle/HR1/112_64/network/admin

ORACLE_HOME=/oracle/HR1/112_64

SAPDATA_HOME=/oracle/HR1

no I don`t use RAC.

The DB and the SAP system is located on the same server.

here the ps -ef | grep oracle output

sles13:hr1adm 59> ps -ef | grep oracle

oracle    2084 23245  0 16:41 pts/4    00:00:00 /bin/sh ./mopatch.sh -v -s SAP12102V2P_1506-20012300.ZIP

oracle    7971     1  0 14:44 ?        00:00:00 /oracle/HR1/11202/bin/tnslsnr LISTENER -inherit

oracle    7980     1  0 14:44 ?        00:00:00 ora_pmon_HR1

oracle    7982     1  0 14:44 ?        00:00:00 ora_psp0_HR1

oracle    7984     1  1 14:44 ?        00:01:13 ora_vktm_HR1

oracle    7988     1  0 14:44 ?        00:00:00 ora_gen0_HR1

oracle    7990     1  0 14:44 ?        00:00:00 ora_diag_HR1

oracle    7992     1  0 14:44 ?        00:00:00 ora_dbrm_HR1

oracle    7994     1  0 14:44 ?        00:00:03 ora_dia0_HR1

oracle    7996     1  0 14:44 ?        00:00:00 ora_mman_HR1

oracle    7998     1  0 14:44 ?        00:00:05 ora_dbw0_HR1

oracle    8000     1  0 14:44 ?        00:00:03 ora_lgwr_HR1

oracle    8002     1  0 14:44 ?        00:00:02 ora_ckpt_HR1

oracle    8004     1  0 14:44 ?        00:00:01 ora_smon_HR1

oracle    8006     1  0 14:44 ?        00:00:00 ora_reco_HR1

oracle    8008     1  0 14:44 ?        00:00:01 ora_mmon_HR1

oracle    8010     1  0 14:44 ?        00:00:01 ora_mmnl_HR1

oracle    8018     1  0 14:44 ?        00:00:00 ora_arc0_HR1

oracle    8020     1  0 14:44 ?        00:00:00 ora_arc1_HR1

oracle    8022     1  0 14:44 ?        00:00:00 ora_arc2_HR1

oracle    8024     1  0 14:44 ?        00:00:00 ora_arc3_HR1

oracle    8026     1  0 14:44 ?        00:00:00 ora_qmnc_HR1

oracle    8041     1  0 14:44 ?        00:00:00 ora_q000_HR1

oracle    8043     1  0 14:44 ?        00:00:00 ora_q001_HR1

oracle    9006  2084  0 16:45 pts/4    00:00:00 /bin/sh ./mopatch.sh -v -s SAP12102V2P_1506-20012300.ZIP

oracle    9007  9006  0 16:45 pts/4    00:00:00 /bin/sh /oracle/HR1/12102/OPatch/opatch apply -silent -verbose -no_relink -local -invPtrLoc /oracle/HR1/12102/oraInst.loc

oracle    9081  9007 52 16:45 pts/4    00:00:05 /oracle/HR1/12102/jdk/bin/java -Xms150m -Xmx256m -XX:MaxPermSize=128M -cp /oracle/HR1/12102/OPatch/ocm/lib/emocmclnt.jar:/oracle/HR1/12102/oui/jlib/OraInstaller.jar:/oracle/HR1/12102/oui/jlib/OraInstallerNet.jar:/oracle/HR1/12102/oui/jlib/OraPrereq.jar:/oracle/HR1/12102/oui/jlib/share.jar:/oracle/HR1/12102/oui/jlib/orai18n-mapping.jar:/oracle/HR1/12102/oui/jlib/xmlparserv2.jar:/oracle/HR1/12102/oui/jlib/emCfg.jar:/oracle/HR1/12102/oui/jlib/ojmisc.jar:/oracle/HR1/12102/OPatch/jlib/opatch.jar:/oracle/HR1/12102/OPatch/jlib/opatchsdk.jar:/oracle/HR1/12102/OPatch/oplan/jlib/automation.jar:/oracle/HR1/12102/OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar:/oracle/HR1/12102/OPatch/jlib/oracle.opatch.classpath.jar:/oracle/HR1/12102/OPatch/oplan/jlib/jaxb/activation.jar:/oracle/HR1/12102/OPatch/oplan/jlib/jaxb/jaxb-api.jar:/oracle/HR1/12102/OPatch/oplan/jlib/jaxb/jaxb-impl.jar:/oracle/HR1/12102/OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar:/oracle/HR1/12102/OPatch/oplan/jlib/OsysModel.jar:/oracle/HR1/12102/OPatch/oplan/jlib/osysmodel-utils.jar:/oracle/HR1/12102/OPatch/oplan/jlib/CRSProductDriver.jar:/oracle/HR1/12102/OPatch/oplan/jlib/oracle.oplan.classpath.jar -DOPatch.ORACLE_HOME=/oracle/HR1/12102 -DOPatch.DEBUG=false -DOPatch.RUNNING_DIR=/oracle/HR1/12102/OPatch -DOPatch.MW_HOME= -DOPatch.WL_HOME= -DOPatch.COMMON_COMPONENTS_HOME= -DOPatch.OUI_LOCATION= -DOPatch.FMW_COMPONENT_HOME= -DOPatch.OPATCH_CLASSPATH= -DOPatch.WEBLOGIC_CLASSPATH= oracle/opatch/OPatch apply -silent -verbose -no_relink -local -invPtrLoc /oracle/HR1/12102/oraInst.loc

hr1adm    9138 21571  0 16:45 pts/2    00:00:00 grep oracle

oracle   12119     1  0 14:46 ?        00:00:04 oracleHR1 (LOCAL=NO)

oracle   12121     1  0 14:46 ?        00:00:02 oracleHR1 (LOCAL=NO)

oracle   12123     1  0 14:46 ?        00:00:06 oracleHR1 (LOCAL=NO)

oracle   12125     1  0 14:46 ?        00:00:01 oracleHR1 (LOCAL=NO)

oracle   12127     1  0 14:46 ?        00:00:01 oracleHR1 (LOCAL=NO)

oracle   12129     1  0 14:46 ?        00:00:03 oracleHR1 (LOCAL=NO)

oracle   12131     1  0 14:46 ?        00:00:00 oracleHR1 (LOCAL=NO)

oracle   12133     1  0 14:46 ?        00:00:00 oracleHR1 (LOCAL=NO)

oracle   12135     1  0 14:46 ?        00:00:03 oracleHR1 (LOCAL=NO)

oracle   12137     1  0 14:46 ?        00:00:01 oracleHR1 (LOCAL=NO)

oracle   12139     1  0 14:46 ?        00:00:00 oracleHR1 (LOCAL=NO)

oracle   12141     1  0 14:46 ?        00:00:05 oracleHR1 (LOCAL=NO)

oracle   12143     1  0 14:46 ?        00:00:00 oracleHR1 (LOCAL=NO)

oracle   13184     1  0 14:51 ?        00:00:00 ora_smco_HR1

root     18333  7819  0 15:31 pts/1    00:00:00 su - oracle

oracle   18334 18333  0 15:31 pts/1    00:00:00 -sh

oracle   20880 20653  0 15:48 ?        00:00:00 /usr/bin/gnome-session

oracle   20966     1  0 15:48 ?        00:00:00 dbus-launch --exit-with-session /usr/bin/gnome-session

oracle   20967     1  0 15:48 ?        00:00:00 /bin/dbus-daemon --fork --print-pid 5 --print-address 9 --session

oracle   20970     1  0 15:48 ?        00:00:00 /usr/lib/GConf/2/gconfd-2

oracle   20975     1  0 15:48 ?        00:00:00 gnome-keyring-daemon --start

oracle   20976     1  0 15:48 ?        00:00:00 /usr/lib/gnome-settings-daemon/gnome-settings-daemon

oracle   20982     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs/gvfsd

oracle   20990 20880  0 15:48 ?        00:00:00 /usr/bin/metacity

oracle   20992     1  0 15:48 ?        00:00:00 /usr/bin/pulseaudio --start --log-target=syslog

oracle   20996     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs//gvfs-fuse-daemon /home/oracle/.gvfs

oracle   21002 20880  0 15:48 ?        00:00:00 gnome-panel

oracle   21004 20880  0 15:48 ?        00:00:05 nautilus

oracle   21006     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs/gvfsd-trash --spawner :1.7 /org/gtk/gvfs/exec_spaw/0

oracle   21008     1  0 15:48 ?        00:00:00 /usr/lib/bonobo/bonobo-activation-server --ac-activate --ior-output-fd=18

oracle   21019     1  0 15:48 ?        00:00:00 /usr/lib/gnome-panel/null_applet --oaf-activate-iid=OAFIID:GNOME_NullApplet_Factory --oaf-ior-fd=24

oracle   21020     1  0 15:48 ?        00:00:00 /usr/lib64/gnome-main-menu/main-menu --oaf-activate-iid=OAFIID:GNOME_MainMenu_Factory --oaf-ior-fd=18

oracle   21022     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs/gvfs-hal-volume-monitor

oracle   21024     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs/gvfs-gphoto2-volume-monitor

oracle   21029 20880  0 15:48 ?        00:00:00 gpk-update-icon

oracle   21030     1  0 15:48 ?        00:00:04 /usr/lib/vmware-tools/sbin64/vmtoolsd -n vmusr

oracle   21042 20880  0 15:48 ?        00:00:00 gnome-volume-control-applet

oracle   21048 20880  0 15:48 ?        00:00:00 python /usr/lib64/python2.6/site-packages/system-config-printer/applet.py

oracle   21058     1  0 15:48 ?        00:00:00 gnome-power-manager

oracle   21059     1  0 15:48 ?        00:00:00 gnome-screensaver

oracle   21096     1  0 15:48 ?        00:00:00 /usr/lib64/gvfs/gvfsd-burn --spawner :1.7 /org/gtk/gvfs/exec_spaw/1

oracle   21521     1  0 15:51 ?        00:00:00 ora_w000_HR1

oracle   22094     1  0 15:53 ?        00:00:00 /usr/lib/notification-daemon-1.0/notification-daemon

oracle   23101     1  0 16:00 ?        00:00:00 /usr/bin/gnome-terminal -x /bin/sh -c cd '/home/oracle/Desktop' && exec $SHELL -l

oracle   23102 23101  0 16:00 ?        00:00:00 gnome-pty-helper

oracle   23103 23101  0 16:00 pts/5    00:00:00 /bin/sh -l

root     23244 21369  0 16:02 pts/4    00:00:00 su - oracle

oracle   23245 23244  0 16:02 pts/4    00:00:00 -sh

best regards

A. Moore

[Former Member]

Ok, not that easy as I first thought.

Btw, no need to post the whole output of 'ps -ef'; that's just confusing. I would have preferred a short answer to my question. OK, I see there are oracleHR1 processes.

Now you can either recheck your whole process of configuration, as suggested by Pradeep (btw no need to post a summary of a SAP note; a link, or just the pure number would suffice), or further try troubleshooting.

For troubleshooting brtools problems in Unix it's a good approach imho to get it working for user oracle or ora<sid> first. Did you try that?

regards

[former_member264831]

Hell Mr. Bodenschatz,

with the new oracle user "oracle" a select command e.g. "select status from v$instance;" works.

sles13:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 11 09:31:01 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status from v$instance;

STATUS

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

OPEN

the BRtools with user oracle doesn`t work

sles13:/usr/sap/HR1/SYS/exe/run> ./brconnect -u / -c -f check

BR0801I BRCONNECT 7.40 (16)

BR0805I Start of BRCONNECT processing: cerjlghd.chk 2015-09-11 09:34:17

BR0252E Function fopen() failed for '/oracle/HR1/11202/sapcheck/cerjlghd.chk' at location main-5

BR0253E errno 2: No such file or directory

BR0121E Processing of log file /oracle/HR1/11202/sapcheck/cerjlghd.chk failed

BR0806I End of BRCONNECT processing: cerjlghd.chk 2015-09-11 09:34:17

BR0280I BRCONNECT time stamp: 2015-09-11 09:34:17

BR0804I BRCONNECT terminated with errors

with user sidadm (hr1adm) the sql statement select status from v$instance; doesnt work.

sles13:hr1adm 57> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 11 09:31:17 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> select status from v$instance;

select status from v$instance

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

SQL>

[Former Member]

Hello,

there are different problems with users oracle and hr1adm.

For hr1adm the main problem is that it doesn't see the database at all.

And looking at the environment, there are a few entries still referringt to Oracle 11.

(Well, I should have noticed this yesterday!)

TNS_ADMIN=/oracle/HR1/112_64/network/admin

ORACLE_HOME=/oracle/HR1/112_64

Somewhere in the upgrade manual or in some SAP note there should be a notice how to set those for Oracle 12c. If in doubt, compare with the environment of user oracle.

(Sorry, I can't crosscheck; no Oracle 12 here so far).

hope this helps

PS:

After writing this, I saw that Indra Gunalan already mentioned ORACLE_HOME