About oracle 10g TNS

 

 

The database listening service is dynamically configured and static.

 

Preparations:

1. create necessary Directories

2. Prepare the init. ora file.

3. Prepare the database creation script

Oradim-delete-sid dbname

Set oracle_sid = dbname

Oradim-new-sid dbname

Orapwd file = c: \ oracle \ product \ 10.2.0 \ db_1 \ database \ pwddbname. ora password = password entries = 2

Sqlplus/nolog

Connect as sysdba

Create spfile from pfile = 'C: \ oracle \ product \ 10.2.0 \ admin \ dbname \ pfile \ init. ora ';

Startup nomount

Alter session set nls_language = american;

Start c: \ create. SQL;

Connect sys/password as sysdba;

Start c: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ ADMIN \ catalog. SQL;

Start c: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ ADMIN \ catproc. SQL;

Connect system/password as sysdba;

Start c: \ oracle \ product \ 10.2.0 \ db_1 \ sqlplus \ admin \ pupbld. SQL;

Alter user system identified "*******";

 

Create. SQL is as follows:

create database DBnamelogfilegroup 1 ('c:\oracle\product\10.2.0\oradata\DBname\redo0101.log','c:\oracle\product\10.2.0\oradata\DBname\redo0102.log','c:\oracle\product\10.2.0\oradata\DBname\redo0103.log') size 50M,group 2 ('c:\oracle\product\10.2.0\oradata\DBname\redo0201.log','c:\oracle\product\10.2.0\oradata\DBname\redo0202.log','c:\oracle\product\10.2.0\oradata\DBname\redo0203.log') size 50M,group 3 ('c:\oracle\product\10.2.0\oradata\DBname\redo0301.log','c:\oracle\product\10.2.0\oradata\DBname\redo0302.log','c:\oracle\product\10.2.0\oradata\DBname\redo0303.log') size 50Mmaxlogfiles 20maxlogmembers 5maxdatafiles 100maxinstances 1datafile 'c:\oracle\product\10.2.0\oradata\DBname\system01.dbf' size 500M autoextend onsysaux datafile 'c:\oracle\product\10.2.0\oradata\DBname\sysaux01.dbf' size 200M autoextend onundo tablespace undotbs1datafile 'c:\oracle\product\10.2.0\oradata\DBname\undo01.dbf' size 50M autoextend ondefault temporary tablespace temptempfile 'c:\oracle\product\10.2.0\oradata\DBname\temp01.bf' size 50M autoextend oncharacter set ZHS16GBKnational character set AL16UTF16;

 

In some cases, you may not understand it too well.