Using username "oracle". Pre-authentication banner message from server: | | ======================================================================== | Unauthorized access is prohibited - violators will be prosecuted | ======================================================================== | | <=================================================> | Legal Disclaimer: Your access is now being Logged | <=================================================> | | | | End of banner message from server Keyboard-interactive authentication prompts from server: | Password: End of keyboard-interactive prompts from server The Illumos Project SunOS 5.11 illumos-4e0c5eff9a June 2018 |-----------------------------------------------------------------| | This system is for the use of authorized users only. | | Individuals using this computer system without authority, or in | | excess of their authority, are subject to having all of their | | activities on this system monitored and recorded by system | | personnel. | | | | In the course of monitoring individuals improperly using this | | system, or in the course of system maintenance, the activities | | of authorized users may also be monitored. | | | | Anyone using this system expressly consents to such monitoring | | and is advised that if such monitoring reveals possible | | evidence of criminal activity, system personnel may provide the | | evidence of such monitoring to law enforcement officials. | |-----------------------------------------------------------------| Your terminal type is now xterm ssh bonnie oracle@bonnie's password: Last login: Thu Apr 5 15:33:07 2018 from baltic.wou.edu /usr/local/lib/std.login: No such file or directory. source /oracle/shells/clyde echo -ne "\033]2;`hostname`\007" -ne cd $ORACLE_HOME/bin cat /etc/*release* LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch cat: /etc/lsb-release.d: Is a directory Oracle Linux Server release 6.9 NAME="Oracle Linux Server" VERSION="6.9" ID="ol" VERSION_ID="6.9" PRETTY_NAME="Oracle Linux Server 6.9" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:6:9:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 6" ORACLE_BUGZILLA_PRODUCT_VERSION=6.9 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=6.9 Red Hat Enterprise Linux Server release 6.9 (Santiago) Oracle Linux Server release 6.9 cpe:/o:oracle:linux:6:9:server sqlplus SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 12 11:56:23 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ^C lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 12-AUG-2019 12:02:52 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bonnie.wou.edu)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused lsnrctl start LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 12-AUG-2019 12:03:11 Copyright (c) 1991, 2014, Oracle. All rights reserved. Starting /oracle/ora12c/12c/12.1.0/home/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.1.0.2.0 - Production System parameter file is /oracle/ora12c/12c/12.1.0/home/network/admin/listener.ora Log messages written to /oracle/ora12c/diag/tnslsnr/bonnie/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bonnie.wou.edu)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bonnie.wou.edu)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 12-AUG-2019 12:03:14 Uptime 0 days 0 hr. 0 min. 1 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/ora12c/12c/12.1.0/home/network/admin/listener.ora Listener Log File /oracle/ora12c/diag/tnslsnr/bonnie/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bonnie.wou.edu)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully sqlplus SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 12 12:03:58 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name: ^C lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 12-AUG-2019 12:04:36 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bonnie.wou.edu)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 12-AUG-2019 12:03:14 Uptime 0 days 0 hr. 1 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/ora12c/12c/12.1.0/home/network/admin/listener.ora Listener Log File /oracle/ora12c/diag/tnslsnr/bonnie/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bonnie.wou.edu)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully prtenv prtenv: Command not found. printenv USER=oracle LOGNAME=oracle HOME=/nfs/kingpin/homeo/oracle PATH=/usr/java/jdk1.8/bin:/opt/banner/banner_clyde/general/exe:/opt/banner/banner_clyde/links:/oracle/ora12c/12c/12.1.0/home/bin:/oracle/ora12c/12c/12.1.0/home/OPatch:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/cluster/bin:/usr/sbin:/opt/VRTS/bin:/opt/SUNWspci3/bin:/usr/opt/SUNWesm/sbin:/usr/openwin/bin:/usr/lib64 MAIL=/var/spool/mail/oracle SHELL=/bin/tcsh SSH_CLIENT=140.211.127.125 34324 22 SSH_CONNECTION=140.211.127.125 34324 140.211.127.179 22 SSH_TTY=/dev/pts/0 TERM=xterm HOSTTYPE=x86_64-linux VENDOR=unknown OSTYPE=linux MACHTYPE=x86_64 SHLVL=1 PWD=/oracle/ora12c/12c/12.1.0/home/bin GROUP=dba HOST=bonnie.wou.edu REMOTEHOST=baltic.wou.edu HOSTNAME=bonnie.wou.edu LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36: CVS_RSH=ssh G_BROKEN_FILENAMES=1 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass KDEDIRS=/usr KDE_IS_PRELINKED=1 LANG=en_US.UTF-8 LESSOPEN=||/usr/bin/lesspipe.sh %s QTDIR=/usr/lib64/qt-3.3 QTINC=/usr/lib64/qt-3.3/include QTLIB=/usr/lib64/qt-3.3/lib MANPATH=/usr/local/man:/usr/openwin/man:/usr/man:/opt/VRTS/man LD_LIBRARY_PATH=/oracle/ora12c/12c/12.1.0/home/lib:/usr/lib64:/usr/local/src:/usr/local/lib:/opt/banner/banner_clyde/general/exe:/opt/temp/usr/local/lib:/opt/banner/banner_clyde/general/exe:/oracle/ora12c/12c/12.1.0/home/lib:/usr/local/lib JAVA_HOME=/usr/java/jdk1.8 ORACLE_SID=clyde TNS_ADMIN=/oracle/ora12c/12c/12.1.0/home/network/admin ORACLE_HOME=/oracle/ora12c/12c/12.1.0/home ORACLE_OWNER=oracle BANNER_ROOT=/opt/banner BANNER_HOME=/opt/banner/banner_clyde EXE_HOME=/opt/banner/banner_clyde/general/exe BANNER_LINKS=/opt/banner/banner_clyde/links DATA_HOME=/opt/banner/banner_clyde/dataload ORA_NLS10=/oracle/ora12c/12c/12.1.0/home/nls/data ORACLE_PATH=/.:/opt/banner/banner_clyde/student/plus:/opt/banner/banner_clyde/general/plus:/opt/banner/banner_clyde/finance/plus:/opt/banner/banner_clyde/links SQLPATH=/.:/opt/banner/banner_clyde/student/plus:/opt/banner/banner_clyde/general/plus:/opt/banner/banner_clyde/finance/plus:/opt/banner/banner_clyde/links ICU_HOME=/usr/local/src BANNER_ADMIN=/opt/banner/banner_clyde/admin ORACLE_BASE=/oracle/ora12c BAN_SPOOL=/nfs/kingpin/homeo/oracle/jobsub/clyde COBOL=/opt/FJSVcbl64 COBPREF=perl $BANNER_LINKS/banfjsv.pl LC_ALL=en_US.UTF8 NLS_LANG=AMERICAN_AMERICA.AL32UTF8 NLS_DATE_FORMAT=DD-MON-RRRR ICU_LIBS=/usr/lib64:/usr/local/src:/usr/local/lib ls -l /oracle/ora12c/12c/12.1.0/home/network/admin/ total 24 -rw-r--r-- 1 oracle dba 333 Apr 3 2017 listener.ora drwxr-xr-x 2 oracle dba 4096 Apr 3 2017 samples -rw-r--r-- 1 oracle dba 373 Oct 31 2013 shrept.lst -rw-r--r-- 1 oracle dba 186 Apr 3 2017 sqlnet.ora -rw-r----- 1 oracle dba 334 Apr 3 2017 tnsnames.ora -rw-r----- 1 oracle dba 334 Apr 4 2017 tnsnames_ORIG.ora cat /oracle/ora12c/12c/12.1.0/home/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/ora12c/12c/12.1.0/home/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CLYDE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bonnie.wou.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clyde.wou.edu) ) ) cat /oracle/ora12c/12c/12.1.0/home/network/admin/sqlnet.ora # sqlnet.ora Network Configuration File: /oracle/ora12c/12c/12.1.0/home/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) cat /oracle/ora12c/12c/12.1.0/home/network/admin/listener.ora # listener.ora Network Configuration File: /oracle/ora12c/12c/12.1.0/home/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bonnie.wou.edu)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) cat $HOME/tnsnames.ora # Generated manually by PHILLIPSA 03MAY2017 ULAMA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = olmec.wou.edu)(PORT = 1521)) (CONNECT_DATE = (SERVER = DEDICATED) (SERVICE_NAME = ulama.wou.edu) ) ) CLYDE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bonnie.wou.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clyde.wou.edu) ) )