Advertisement
Guest User

Untitled

a guest
Oct 15th, 2013
838
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.58 KB | None | 0 0
  1. Create controlfile reuse set database "XE"
  2. *
  3. ERROR at line 1:
  4. ORA-01034: ORACLE not available
  5. Process ID: 0
  6. Session ID: 0 Serial number: 0
  7.  
  8.  
  9. BEGIN dbms_backup_restore.zerodbid(0); END;
  10.  
  11. *
  12. ERROR at line 1:
  13. ORA-01034: ORACLE not available
  14. Process ID: 0
  15. Session ID: 0 Serial number: 0
  16.  
  17.  
  18. ORA-01034: ORACLE not available
  19. ORA-27101: shared memory realm does not exist
  20. Linux-x86_64 Error: 2: No such file or directory
  21. ORA-00119: invalid specification for system parameter LOCAL_LISTENER
  22. ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))'
  23. Create controlfile reuse set database "XE"
  24. *
  25. ERROR at line 1:
  26. ORA-01034: ORACLE not available
  27. Process ID: 0
  28. Session ID: 0 Serial number: 0
  29.  
  30.  
  31. alter system enable restricted session
  32. *
  33. ERROR at line 1:
  34. ORA-01034: ORACLE not available
  35. Process ID: 0
  36. Session ID: 0 Serial number: 0
  37.  
  38.  
  39. alter database "XE" open resetlogs
  40. *
  41. ERROR at line 1:
  42. ORA-01034: ORACLE not available
  43. Process ID: 0
  44. Session ID: 0 Serial number: 0
  45.  
  46.  
  47. alter database rename global_name to "XE"
  48. *
  49. ERROR at line 1:
  50. ORA-01034: ORACLE not available
  51. Process ID: 0
  52. Session ID: 0 Serial number: 0
  53.  
  54.  
  55. alter system switch logfile
  56. *
  57. ERROR at line 1:
  58. ORA-01034: ORACLE not available
  59. Process ID: 0
  60. Session ID: 0 Serial number: 0
  61.  
  62.  
  63. alter system checkpoint
  64. *
  65. ERROR at line 1:
  66. ORA-01034: ORACLE not available
  67. Process ID: 0
  68. Session ID: 0 Serial number: 0
  69.  
  70.  
  71. alter database drop logfile group 3
  72. *
  73. ERROR at line 1:
  74. ORA-01034: ORACLE not available
  75. Process ID: 0
  76. Session ID: 0 Serial number: 0
  77.  
  78.  
  79. ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
  80. *
  81. ERROR at line 1:
  82. ORA-01034: ORACLE not available
  83. Process ID: 0
  84. Session ID: 0 Serial number: 0
  85.  
  86.  
  87. select tablespace_name from dba_tablespaces where tablespace_name='USERS'
  88. *
  89. ERROR at line 1:
  90. ORA-01034: ORACLE not available
  91. Process ID: 0
  92. Session ID: 0 Serial number: 0
  93.  
  94.  
  95. select sid, program, serial#, username from v$session
  96. *
  97. ERROR at line 1:
  98. ORA-01034: ORACLE not available
  99. Process ID: 0
  100. Session ID: 0 Serial number: 0
  101.  
  102.  
  103. alter user sys identified by "oracle"
  104. *
  105. ERROR at line 1:
  106. ORA-01034: ORACLE not available
  107. Process ID: 0
  108. Session ID: 0 Serial number: 0
  109.  
  110.  
  111. alter user system identified by "oracle"
  112. *
  113. ERROR at line 1:
  114. ORA-01034: ORACLE not available
  115. Process ID: 0
  116. Session ID: 0 Serial number: 0
  117.  
  118.  
  119. alter system disable restricted session
  120. *
  121. ERROR at line 1:
  122. ORA-01034: ORACLE not available
  123. Process ID: 0
  124. Session ID: 0 Serial number: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement