Installation and use of the oracle11g Database

Installation and use of the oracle11g Database

I installed oracle databases twice at school, but I never learned how to use them. What is missing is creating user tablespaces.

Temporary tablespace -- data table space -- authorize the user (SID-tablespace-user-table)

1. sqlplus Logon

/ as sysdba  

2. Create a temporary tablespace

createtemporary tablespace user_temp     tempfile'D:\oracle\oradata\Oracle9i\user_temp.dbf'     size50m     autoextendon     next50m maxsize 20480m     extent managementlocal;  

3. Create a data table space

create tablespace user_data   logging   datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'   size 50m   autoextend on   next 50m maxsize 20480m     extent management local;  

4. Create a user and specify a tablespace

create user username identified by password   default tablespace user_data   temporary tablespace user_temp;   

5. Authorize the user

grant connect,resource,dba to username  

6. Exit

exit  

FAQs:

1. Firewall is not disabled

Telnet ip port number (firewall and listener cannot be viewed)

2. Listening Service

Service not started, ip address and port number

3. Listener Configuration

Linster file (configuration)

(SID_DESC =      (GLOBAL_DBNAME = ORCL)      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)      (SID_NAME = ORCL)      )  

Tips:

1. Enable telent in Windows:

Control Panel-programs and functions-enable or disable Windows functions-select telnet Client

2. Open the service window:

First WIN + R and then services. msc