非图形界面linux创建oracle的实例

1.查看oracle相关的系统参数

$su - oracle //进入oracle用户模式下

$echo $ORACLE_HOME 

$echo $ORACLE_BASE   //查看oracle的base目录

2.创建实例配置文件

$cd $ORACLE_HOME

$cd dbs

cp init.ora  initcloud.ora     (命名规则:initSID.ora)

vim  initcloud.ora

3.相关文件创建

0）文件修改完成后，在ORACLE_BASE/admin目录下，创建一个与SID一致的目录cloud

1）在cloud目录下创建:mkdir adump bdump cdump pfile udump

2）在ORACLE_BASE/oradata 目录下创建cloud目录

需要的基本设置已经弄完了，开始创建新的实例

4.添加环境变量参数：

export ORACLE_SID=cloud       #可以写到/etc/profile或者~/.bash_profile中

5.创建实例

sqlplus / as sysdba

startup nomount

6.测试登录：

1）添加内容到tnsnames.ora

2）sqlplus   /nolog

conn   用户名/密码@实例名

在CRT中进入oracle

--连接sqlplus

按照下面写完代码直接复制进去回车就行了

---建立用户代码为：CREATE

USER

"用户名字"

PROFILE

"DEFAULT"

IDENTIFIED

BY

"密码"

DEFAULT

TABLESPACE

"指定表空间名字"

TEMPORARY

TABLESPACE

"临时表空间"

ACCOUNT

UNLOCK

---赋权

begin

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

DICTIONARY

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

SYSTEM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

ALTER

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CONNECT

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

INDEX

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

VIEW

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DELETE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

PUBLIC

DATABASE

LINK

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

TRIGGER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

INDEX

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

VIEW

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

PUBLIC

SYNONYM

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

EXECUTE

ANY

PROCEDURE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

GRANT

ANY

PRIVILEGE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

GRANT

ANY

ROLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TRIGGER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

INSERT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

DICTIONARY

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

DROP

ANY

SEQUENCE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

SELECT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

UNLIMITED

TABLESPACE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

UPDATE

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

COMMENT

ANY

TABLE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

ANY

TYPE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

TABLESPACE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

CREATE

USER

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

EXP_FULL_DATABASE

TO

用户名'

EXECUTE

IMMEDIATE

'GRANT

IMP_FULL_DATABASE

TO

用户名'

End

---或者直接给DBA权限

---