linux oralce 操作

1,安装完成后.首先我们启动监听

有时一安装就启动了,先关闭监听

[oracle@localhost /]$ lsnrctl stop

[oracle@localhost /]$ lsnrctl start
..........

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-APR-2012 01:27:03
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfullysqlplus /nolog

2,

sqlplus /nolog

SQL> conn / as sysdba

SQL> startup

SQL> select username from dba_users;

SQL> create user psdb_dev identified by psdf_dev;

SQL> grant connect to psdb_dev;

SQL> grant resource to psdb_dev;

SQL> grant create session to psdb_dev;