oracle启动

最新推荐文章于 2024-09-03 12:14:50 发布

最新推荐文章于 2024-09-03 12:14:50 发布 · 80 阅读

文章标签：

1.oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Feb 21 16:36:40 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 16034119

2.oracle@linux:~> lsnrctl start

启动成功。

建立用户：useradd –d /home/abc –s /bin/csh –m abc

修改密码：passwd abc

数据库用户：

CREATE TABLESPACE abc

LOGGING

DATAFILE '/opt/oracle/oradata/abc.ora' SIZE

100m AUTOEXTEND

ON NEXT 200m MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER abc PROFILE DEFAULT

IDENTIFIED BY abc DEFAULT TABLESPACE abc

ACCOUNT UNLOCK;

GRANT CONNECT TO abc WITH ADMIN OPTION;

GRANT DBA TO abc WITH ADMIN OPTION;

GRANT CREATE ANY TABLE TO abc WITH ADMIN OPTION;