SHARE
TWEET

Untitled

a guest Jun 25th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #ORACLE
  2. export ORACLE_BASE=/oracle18c/app/oracle
  3. export ORACLE_HOME=$ORACLE_BASE/product/18.0.0/dbhome_1
  4. export PATH=/usr/sbin:/usr/local/bin:$PATH
  5. export PATH=$ORACLE_HOME/bin:$PATH
  6. export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
  7. export ORACLE_LIBPATH=$ORACLE_HOME/lib
  8. export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$CLASSPATH
  9. export ORACLE_HOSTNAME=$HOSTNAME
  10. export ORA_INVENTORY=/oracle18c/app/oraInventory
  11. export DATA_DIR=$ORACLE_BASE/oradata
  12. export TNS_ADMIN=$ORACLE_HOME/network/admin
  13. export ADR_HOME=$ORACLE_BASE/diag
  14. #--------------------------------------------------------------------
  15. export ORACLE_SID=orcl
  16. export ORACLE_UNQNAME=orcl
  17. export PDB_NAME=pdb
  18. export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
  19. #--------------------------------------------------------------------
  20. export TMP=/tmp; export TMPDIR=$TMP; export TEMP=$TMP
  21.      
  22. oracle@sergey-Bionic:~$ lsnrctl status
  23.  
  24. LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 25-APR-2019 17:35:43
  25.  
  26. Copyright (c) 1991, 2018, Oracle.  All rights reserved.
  27.  
  28. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sergey-Bionic)(PORT=1521)))
  29. STATUS of the LISTENER
  30. ------------------------
  31. Alias                     LISTENER
  32. Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
  33. Start Date                25-APR-2019 16:50:53
  34. Uptime                    0 days 0 hr. 44 min. 49 sec
  35. Trace Level               off
  36. Security                  ON: Local OS Authentication
  37. SNMP                      OFF
  38. Listener Parameter File   /oracle18c/app/oracle/product/18.0.0/dbhome_1/network/admin/listener.ora
  39. Listener Log File         /oracle18c/app/oracle/diag/tnslsnr/sergey-Bionic/listener/alert/log.xml
  40. Listening Endpoints Summary...
  41.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sergey-Bionic)(PORT=1521)))
  42.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  43. The listener supports no services
  44. The command completed successfully
  45. oracle@sergey-Bionic:~$ ss -elpunt | grep -E "^Net|tnslsnr"
  46. Netid  State    Recv-Q   Send-Q      Local Address:Port      Peer Address:Port                                                                                  
  47. tcp    LISTEN   0        128                     *:1521                 *:*      users:(("tnslsnr",pid=3394,fd=8)) uid:54321 ino:39696 sk:12 v6only:0 <->      
  48. oracle@sergey-Bionic:~$
  49.      
  50. oracle@sergey-Bionic:/$ strace -f -o /tmp/strace.log $ORACLE_HOME/bin/sqlplus /nolog
  51.  
  52. SQL*Plus: Release 18.0.0.0.0 - Production on Thu Apr 25 18:02:09 2019
  53. Version 18.3.0.0.0
  54.  
  55. Copyright (c) 1982, 2018, Oracle.  All rights reserved.
  56.  
  57. SQL> connect sys/oracle18c as sysdba;
  58. ERROR:
  59. ORA-12547: TNS:lost contact
  60.  
  61.  
  62. SQL>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top