oracle 初始化

新建表空间无线增长：create tablespace MC logging datafile '/data/oracle/mc/mc.dbf' size 512M autoextend on next 128M maxsize unlimited extent management local segment space management auto;

新建临时表空间：create temporary tablespace MC_TEMP tempfile '/data/oracle/mc/mc_temp.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;

新建用户：create user mc identified by mc default tablespace MC temporary tablespace MC_TEMP;

赋权限：grant connect,resource,dba to username;

The listener supports no services

# listener.ora Network Configuration File: /data/oracle/product/12.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (SID_NAME = orcl)
  )
)
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.144)(PORT = 1521))
    )
  )


ADR_BASE_LISTENER = /data/oracle

shutdown immediate

startup