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;