Category Archives: Database administration

How To Resize the Online Redo Logfiles

How To Resize the Online Redo Logfiles Single Instance: 1. First see the size of the current logs: > sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 … Continue reading

Posted in Database administration | 1 Comment

Database Characterset And Supported Langues

  Characterset Supported Languages (+ English) WE8ISO8859P15 (ISO 8859-15), WE8MSWIN1252 Albanian, Basque, Breton, Catalan, Cornish, Danish, Dutch, Finnish, French, Frisian, Galician, German, Greenlandic, Irish Gaelic (new orthography), Italian, Luxemburgish, Norwegian, Portuguese, Rhaeto-Romanic, Scottish Gaelic, Spanish, Swedish . The Euro symbol … Continue reading

Posted in Database administration | Leave a comment

NLS_LANG in Oracle

Operating System Locale NLS_LANG Value Arabic (U.A.E.) ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 Bulgarian BULGARIAN_BULGARIA.CL8MSWIN1251 Catalan CATALAN_CATALONIA.WE8MSWIN1252 Chinese (PRC) SIMPLIFIED CHINESE_CHINA.ZHS16GBK Chinese (Taiwan) TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950 Croatian CROATIAN_CROATIA.EE8MSWIN1250 Czech CZECH_CZECH REPUBLIC.EE8MSWIN1250 Danish DANISH_DENMARK.WE8MSWIN1252 Dutch (Netherlands) DUTCH_THE NETHERLANDS.WE8MSWIN1252 English (United Kingdom) ENGLISH_UNITED KINGDOM.WE8MSWIN1252 English (United … Continue reading

Posted in Database administration | Leave a comment

Rename tablespace in oracle 10g

Rename tablespace in oracle 10g SQL>CREATE SMALLFILE TABLESPACE “USERS02” DATAFILE’+DGROUP1′ SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; SQL> alter tablespace users02 rename to USERS; Tablespace altered. SQL> alter tablespace users rename to USER_SPACE02; Tablespace altered. SQL> ALTER … Continue reading

Posted in Database administration | Leave a comment

Database Listener file for multiple database

Oracle database Single Listener file for to listen for multiple database is follows. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = db1) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = db1) … Continue reading

Posted in Database administration | Leave a comment

How to create undo tablespace in oracle RAC

1) Create Undo tablespace UNDOTBS01 SQL> create undo tablespace UNDOTBS01 DATAFILE ‘+DATAGROUP’ SIZE 4g; Tablespace created. SQL> @asm NAME TOTAL_GB FREE_GB —————————— ———- ———- DATAGROUP 249.995117 11.46875 IDXGROUP 149.99707 7.55761719 2) Create Undo tablespace UNDOTBS02 SQL> create undo tablespace UNDOTBS02 … Continue reading

Posted in Database administration | 3 Comments

how to add datafile to tablespace on ASM

  Add datafile to tablespace ¬†ASM diskgroup ¬†DATAGROUP SQL> alter tablespace USER-TABLESPACE add datafile ‘+DATAGROUP’ size 10G; Tablespace altered. SQL>

Posted in Database administration | 5 Comments