Oracle Issue record (i)

Oracle cannot be accessed remotely if it does not start the monitoring service, and an error occurs if using OCI or SQL developer.

Start TNS Monitor: Lsnrctl start

View TNS Monitor: Lsnrctl status

Stop TNS monitoring: Lsnrctl stop

Oracle Remote login:

Sqlplus Usrname/[email protected]:p Ort/sid

IP is the target Oracle host IP address, port is the target Oracle Listener port number, SID is the target Oracle SID.

Among them, the SID can be through the command show parameter instance_name; or select instance_name from v$instance; View

Oracle tablespace, build user, authorize

To create a temporary table space:

CREATE Temporary tablespace dba_temp
Tempfile ' D:\Oracle\oradata\DBA1\DATAFILE\DBA\DBA_TEMP. DBF '
SIZE 64M
Autoextend on
NEXT 64M MAXSIZE 512M
EXTENT MANAGEMENT LOCAL;

To create a table space:

CREATE tablespace Dba_data
LOGGING
DataFile ' D:\Oracle\oradata\DBA1\DATAFILE\DBA\DBA. DBF '
SIZE 128M
Autoextend on
NEXT 128M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL;

To create a user:

CREATE USER Test_user identified by password
DEFAULT tablespace dba_temp
Temporary tablespace dba_data;

Authorized:

GRANT
Create SESSION, create any TABLE, create any VIEW, create any INDEX, create any PROCEDURE,
Alter any TABLE, alter any PROCEDURE,
Drop any TABLE, drop no VIEW, drop any INDEX, drop any PROCEDURE,
SELECT any table, INSERT any table, UPDATE all table, DELETE any table
to Test_user;

To grant DBA Authority:

GRANT dba to Test_user;

Note: The DBA is a role in Oracle. Granting a role to a user is equivalent to the user having the role's identity, and can use the resources that are available to all roles.

are summarized in their own use of Oracle, and time is constantly updated. Next prepare to learn Oracle through the book system, and at the same time to quickly master the OCI, the next time to send a OCI study records.

In addition, recently in the project team to write code when the lock, resulting in performance degradation, later if there is time will be further learning the knowledge of multi-threaded, and then share to everyone ha!!!

Oracle Issue record (i)