Guest User

Untitled

a guest
Oct 6th, 2020
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.60 KB | None | 0 0
  1. Tue Oct 6 11:50:18 UTC 2020
  2. Configure DB as oracle user
  3. Check user
  4.  
  5. SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 6 11:50:18 2020
  6.  
  7. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  8.  
  9. Connected to an idle instance.
  10.  
  11. SQL> ORACLE instance started.
  12.  
  13. Total System Global Area 3036676096 bytes
  14. Fixed Size 2929016 bytes
  15. Variable Size 1778388616 bytes
  16. Database Buffers 1241513984 bytes
  17. Redo Buffers 13844480 bytes
  18. Database mounted.
  19. SQL>
  20. File created.
  21.  
  22. SQL> Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  23. NID check db name
  24.  
  25. SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 6 11:50:29 2020
  26.  
  27. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  28.  
  29.  
  30. Connected to:
  31. Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  32.  
  33. SQL> Media recovery complete.
  34. SQL> ORACLE instance shut down.
  35. SQL> Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  36.  
  37. SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 6 11:50:33 2020
  38.  
  39. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  40.  
  41. Connected to an idle instance.
  42.  
  43. SQL> ORACLE instance started.
  44.  
  45. Total System Global Area 3019898880 bytes
  46. Fixed Size 2928968 bytes
  47. Variable Size 553651896 bytes
  48. Database Buffers 2449473536 bytes
  49. Redo Buffers 13844480 bytes
  50. Database mounted.
  51. SQL>
  52. File created.
  53.  
  54. SQL>
  55. Database altered.
  56.  
  57. SQL> alter database open resetlogs
  58. *
  59. ERROR at line 1:
  60. ORA-03113: end-of-file on communication channel
  61. Process ID: 179
  62. Session ID: 237 Serial number: 27260
  63.  
  64.  
  65. SQL> ERROR:
  66. ORA-03114: not connected to ORACLE
  67.  
  68.  
  69. SQL> ERROR:
  70. ORA-03114: not connected to ORACLE
  71.  
  72.  
  73. SQL> ORA-24324: service handle not initialized
  74. ORA-01041: internal error. hostdef extension doesn't exist
  75. SQL> SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0
  76. Unsafe to proceed
  77. ORA-03114: not connected to ORACLE
  78.  
  79. SQL> ERROR:
  80. ORA-03114: not connected to ORACLE
  81.  
  82.  
  83. SQL> Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  84. update password
  85.  
  86. Enter password for SYS:
  87. create pdb : PDB1
  88. Enter PDBADMIN User Password:
  89. ^H ^HThe database "ORCL" could not be started. Check the existence of the database.
  90.  
  91. LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-OCT-2020 11:51:18
  92.  
  93. Copyright (c) 1991, 2016, Oracle. All rights reserved.
  94.  
  95. Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
  96.  
  97. TNSLSNR for Linux: Version 12.1.0.2.0 - Production
  98. System parameter file is /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
  99. Log messages written to /u01/app/oracle/diag/tnslsnr/6047148f17cd/listener/alert/log.xml
  100. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  101. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  102.  
  103. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
  104. STATUS of the LISTENER
  105. ------------------------
  106. Alias LISTENER
  107. Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
  108. Start Date 06-OCT-2020 11:51:19
  109. Uptime 0 days 0 hr. 0 min. 0 sec
  110. Trace Level off
  111. Security ON: Local OS Authentication
  112. SNMP OFF
  113. Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
  114. Listener Log File /u01/app/oracle/diag/tnslsnr/6047148f17cd/listener/alert/log.xml
  115. Listening Endpoints Summary...
  116. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  117. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  118. The listener supports no services
  119. The command completed successfully
  120.  
  121. SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 6 11:51:19 2020
  122.  
  123. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  124.  
  125.  
  126. Connected to:
  127. Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  128.  
  129. SQL> BEGIN dbms_xdb_config.sethttpsport (5500); END;
  130.  
  131. *
  132. ERROR at line 1:
  133. ORA-06550: line 1, column 7:
  134. PLS-00201: identifier 'DBMS_XDB_CONFIG.SETHTTPSPORT' must be declared
  135. ORA-06550: line 1, column 7:
  136. PL/SQL: Statement ignored
  137.  
  138.  
  139. SQL>
  140. System altered.
  141.  
  142. SQL> Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
  143. Oracle Interim Patch Installer version 12.2.0.1.8
  144. Copyright (c) 2020, Oracle Corporation. All rights reserved.
  145.  
  146. Please check the arguments and try again.
  147.  
  148. OPatch failed with error code 135
  149. writing relink log to: /u01/app/oracle/product/12.1.0/dbhome_1/install/relink.log
  150.  
  151. DONE!
Add Comment
Please, Sign In to add comment