純粹筆記!!!!!
1.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
02. Ora9 EDIT
[A]
Command
sqlplus
sys as sysdba
w12345
shutdown immediate;
startup
startup mount; (single mode)
alter database open; (多工mode)
[B]
啟動資料庫連線
LSNRCTL START
[C]
listener.ora
[D]
1、 create pfile='d:/pfile' from spfile;
2、修改pfile檔，裏面加入*._allow_resetlogs_corruption=TRUE
3、Startup nomount pfile='d:/pfile';
4、Alter database mount;
5、Recover database until cancel;
6、Alter database open resetlogs;
7、Select * from test1;
[E]
UNDOTBS01.DBF文件太大的解決辦法
1) recover datafile '/usr/oradata/kelong70/undotbs01.dbf' ;
2) alter database datafile '/usr/oradata/kelong70/undotbs01.dbf' online;
3) create undo tablespace undotbs2 datafile '.............' size ..m ; (from above post)
4) alter system set undo_tablespace=undotbs2 scope=both;
5) alter system set undo_management=auto scope = spfile;
6) shutodwn immediate;
7) startup;
8) drop tablespace undotbs1 including contents and datafiles;
解決辦法：
1.升級到9205
2.停止undo tablespace
3.縮小undo tablespace
-- undo tablespace
create undo tablespace undotBS2 datafile 'C:\oracle\oradata\eoffice\UNDOTBS1.DBF' size 100m;
-- 建置新的空間 undo_tablespace
alter system set undo_tablespace=undotBS2;
-- Drop 原有空間
drop tablespace undotbs1 including contents;
--查看所有表格空間
select * from dba_tablespaces
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
01. Ora8 SetUpb
[A]
1.Oracle Database Assistant
2.Create a database
3.Custom
4.Advanced Replication
5ｐatabase Name=orcl(wttt)
SID = orcl(wttt)
Initialization Filename d:\orant\database\initorcl
Password = w12345
7.預設值
[B]
1.開啟<服務>
2.啟動 OracleServiceORC
OracleStartORCLE
OracleTNSListener80
<啟動.自動>
[C]
1.Administrator Toolbar
2.標題->Customize->Database
3.Service = Oracle
Default <勾選>
User = SYSTEM
Password = Manage
[D]
Storage 擴充區塊
Rb0 2000
Rb1 2000
Sysrol 2000
[E] initwttt.ora
-》OPEN_CURSORS = 200
[F] 中文問題
C:\winnt\regedit
HKEY_LOCAL_MACHINE
SOFTWARE
ORACLE
NLS_LANG
"TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5"
改成 "AMERICAN_AMERICA"
