Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.61 KB | None | 0 0
  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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement