启动关闭

1.关闭监听
lsnrctl stop

2.关闭实例
sqlplus / as sysdba
SQL> shutdow immediate;

3.启动实例
sqlplus / as sysdba
SQL> startup;

4.启动监听
lsnrctl start

5.配置local_listener参数
sqlplus / as sysdba

6.配置参数
alter system set local_listener=”(address = (protocol = tcp)(host = 192.168.73.73)(port = 1521))”;

7.查看show parameter local_listener;
Oracle 使用 - 图1

8.启动监听
lsnrctl status

以下 为可选操作 ：

创建数据库文件
CREATE TABLESPACE MyDataBase LOGGING DATAFILE ‘/opt/oracle/oradata/orcl/MyDataBase.dbf’ SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;

创建数据库临时文件
create temporary TABLESPACE MyDataBase_temp tempfile ‘/opt/oracle/oradata/orcl/MyDataBase_temp.dbf’ SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;

创建用户与上述两个文件形成映射关系
CREATE USER xiaoming IDENTIFIED BY Admin123 DEFAULT TABLESPACE MyDataBase TEMPORARY TABLESPACE MyDataBase_temp;

添加用户权限
grant connect,resource,dba to xiaoming;
grant create session to xiaoming;

删除数据库
conn sys/dwh as sysdba;
drop tablespace MyDataBase including contents and datafiles;
drop tablespace MyDataBase_temp including contents and datafiles;

删除用户
drop user xiaoming cascade;