Oracle Connections

Installation and Configuration › How to Prepare Your DBMS Environment › Tasks to Create an Oracle DBMS › Oracle Connections

Oracle Connections

Oracle SQL*Net is used for client access to the database server. Although Oracle provides two utilities (SQL*Net Configuration tool and Network Manager tool) for defining your network, clients, and server, you need a network administrator to perform this task. The server system administrator is usually the best candidate.

Note: For more information about these utilities, see the Oracle SQL*Net Administrator's Guide.

SQL*Net requires certain files on both the server and client. These files can be generated by the Oracle networking tools, but can also be created using a text editor. Because Oracle does not support those sites that generate these files manually, it is better to use the appropriate Oracle utilities. The following lists the files required by SQL*Net:

File Name	Required On	File Contents
TNSNAMES.ORA	Client and Server	A list of service names and connect descriptors for network destinations (tells the client where it can make connections)
SQLNET.ORA	Client and Server	A list of optional diagnostic parameters
LISTENER.ORA	Server only	A list of names and addresses of all listeners on a computer and the Oracle SIDs for the databases known on that computer

Oracle SQL Commands

If a graphical DBMS access tool is not available, you can use Oracle SQL commands through SQL*DBA or SQL*Plus.

The following is an example of how to create a tablespace using the CREATE TABLESPACE command:

CREATE TABLESPACE mm_data	/* The tablespace name. */
DATAFILE 'C:\ORANT\DATABASE\mmdata.dat'ᾉ/* The data file name. */
SIZE integer_value K or M or G	/* The data file size */
DEFAULT STORAGE (	/* The default storage parameters */
    INITIAL integer_value K or M or G	/* The initial extent size */
    NEXT integer_value K or M or G	/* The next extent size */
    PCTINCREASE integer_value	/* The percent to grow extents */
    MINEXTENTS integer_value	/* The minimum number of extents */
    MAXEXTENTS integer_value	/* The maximum number of extents */
);

The following is an example of how to create an Oracle user using the CREATE USER command:

CREATE USER mm_user_1  /* The user id name */
IDENIFIED BY password  /* The user password */
DEAFULT TABLESPACE tablespace_name  /* The user's default tablespace */
TEMPORARY TABLESPACE tablespace_name  /* The user's temporary tablespace */
QUOTA unlimited_or_integer_K_M_G ON tablespace_name /* The user's quota on a tablespace */
;

The following is an example of how to grant user privileges using the GRANT command:
```
GRANT role_or_privilege_name	
TO user_or_role	
;
```

Email CA about this topic