Oracle 11G creates tablespaces, users, configuration listening, and TNS, 11 gtns

Oracle 11G creates tablespaces, users, configuration listening, and TNS, 11 gtns

Recently, I have been installing various versions of the oralce database for testing, 11 GB, 32-bit, 64-bit, 12C. Every time I go through the tablespace, what about users and tns, record it here and you no longer need to use Baidu to find it.

1. Create a tablespace,User

Run the following statement in plsql to create an Oracle tablespace.

/* Divided into four steps */
/* Step 2: create a temporary tablespace */
Create temporary tablespace tempdb
Tempfile 'C: \ oracledata \ cognos_temp.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;

/* Step 2: create a data table space */
Create tablespace budget
-- Logging
Datafile 'C: \ oracledata \ cognos_data.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;

/* Step 2: create a user and specify the tablespace */
Create user aicognos identified by qaz #1234
Default tablespace budget
Temporary tablespace tempdb;

/* Step 4: grant permissions to users */
Grant connect, resource, dba to aicognos;

2. Configure the server listening File

C $ \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN listener. ora

COGNOSDB86 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROCCOGNOSDB86 ))
(ADDRESS = (PROTOCOL = TCP) (Host = 10.1.1.86) (Port = 1521 ))
)

SID_LIST_COGNOSDB86 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1)
(SID_NAME = COGNOSDB86)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1)
(PROGRAM = extproc)
)
)

STARTUP_WAIT_TIME_COGNOSDB86 = 0
CONNECT_TIMEOUT_COGNOSDB86 = 10
TRACE_LEVEL_COGNOSDB86 = OFF

 

3. Configure TNS

Tnsnames. ora of c $ \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN

COGNOSDB86 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = COGNOSTEST4.ai.com) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cognosdb86.ai.com)
)
)

Export lr_connection_data =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)