https://blog.youkuaiyun.com/csdnhadoopzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/csdnhadoop/article/details/69377915https://blog.youkuaiyun.com/csdnhadoop/article/details/69377915csdnhadoopThu, 06 Apr 2017 10:27:42 +0800 alter table TRIG_SQL_2 modify sqltext blob; alter table TRIG_SQL_2 modify sqltext blob                               * ERROR at line 1: ORA-22858: invalid alteration of datatype SQL>]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/68594365https://blog.youkuaiyun.com/csdnhadoop/article/details/68594365csdnhadoopThu, 30 Mar 2017 23:08:06 +0800 archive log list; Database log mode       Archive Mode Automatic archival       Enabled Archive destination       /home/oradata/archlogs Oldest online log sequence     15 Next lo]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/68593566https://blog.youkuaiyun.com/csdnhadoop/article/details/68593566csdnhadoopThu, 30 Mar 2017 23:06:40 +0800 startup nomount; ORACLE instance started. Total System Global Area 6680915968 bytes Fixed Size    2213936 bytes Variable Size 3892316112 bytes Database Buffers 2751463424 bytes Redo Buf]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/68592403https://blog.youkuaiyun.com/csdnhadoop/article/details/68592403csdnhadoopThu, 30 Mar 2017 23:05:23 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/68061462https://blog.youkuaiyun.com/csdnhadoop/article/details/68061462csdnhadoopWed, 29 Mar 2017 10:53:26 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/68061224https://blog.youkuaiyun.com/csdnhadoop/article/details/68061224csdnhadoopWed, 29 Mar 2017 10:47:39 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/66972123https://blog.youkuaiyun.com/csdnhadoop/article/details/66972123csdnhadoopMon, 27 Mar 2017 17:53:40 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/66971793https://blog.youkuaiyun.com/csdnhadoop/article/details/66971793csdnhadoopMon, 27 Mar 2017 15:03:18 +0800 startup pfile='/oracle/p2.ora' nomount; LRM-00121: ',' is not an allowable value for 'remote_login_passwordfile' ORA-01078: failure in processing system parameters SQL> 注释掉 remote_login_p]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/66971418https://blog.youkuaiyun.com/csdnhadoop/article/details/66971418csdnhadoopMon, 27 Mar 2017 14:36:06 +0800 select supplemental_log_data_min from v$database; SUPPLEME -------- NO SQL> select supplemental_log_data_min from v$database; SUPPLEME -------- NO SQL> alter database add ]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/65630615https://blog.youkuaiyun.com/csdnhadoop/article/details/65630615csdnhadoopFri, 24 Mar 2017 14:34:29 +0800 alter database backup controlfile to trace as '/tmp/controfile_hr.txt'; Database altered. SQL> exit 然后去/tmp/controfile_hr.txt里面找下创建控制文件的sql，找到 STARTUP NOMOUNT ]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/65445219https://blog.youkuaiyun.com/csdnhadoop/article/details/65445219csdnhadoopThu, 23 Mar 2017 16:31:21 +0800 startup pfile='/oracle/p1.ora'; ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes SQL> 问题是 LOG_ARCHIVE_DEST_2哪一行末尾少了一个']]>https://blog.youkuaiyun.com/csdnhadoop/article/details/65444732https://blog.youkuaiyun.com/csdnhadoop/article/details/65444732csdnhadoopThu, 23 Mar 2017 16:00:15 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/65443631https://blog.youkuaiyun.com/csdnhadoop/article/details/65443631csdnhadoopThu, 23 Mar 2017 14:46:46 +0800 create pfile='/oracle/p1.ora' from spfile; create pfile='/oracle/p1.ora' from spfile * ERROR at line 1: ORA-07391: sftopn: fopen error, unable to open text file. SQL> startup nomount]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/65442416https://blog.youkuaiyun.com/csdnhadoop/article/details/65442416csdnhadoopThu, 23 Mar 2017 13:21:25 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/64923744https://blog.youkuaiyun.com/csdnhadoop/article/details/64923744csdnhadoopWed, 22 Mar 2017 19:04:18 +0800 alter database mount 2> ; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ====]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/64921997https://blog.youkuaiyun.com/csdnhadoop/article/details/64921997csdnhadoopWed, 22 Mar 2017 17:05:22 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/64921627https://blog.youkuaiyun.com/csdnhadoop/article/details/64921627csdnhadoopWed, 22 Mar 2017 16:56:08 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/64438518https://blog.youkuaiyun.com/csdnhadoop/article/details/64438518csdnhadoopTue, 21 Mar 2017 10:07:29 +0800 alter database open; alter database open * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/home/oradata/crltest/system01.dbf' SQL>  alter ]]>https://blog.youkuaiyun.com/csdnhadoop/article/details/64123364https://blog.youkuaiyun.com/csdnhadoop/article/details/64123364csdnhadoopMon, 20 Mar 2017 11:21:56 +0800https://blog.youkuaiyun.com/csdnhadoop/article/details/63792065https://blog.youkuaiyun.com/csdnhadoop/article/details/63792065csdnhadoopSun, 19 Mar 2017 23:21:01 +0800