oracle rak建表空间,blueskiner

[mailz@/cdr2/home/mailz]$ su - oracle

oracle's Password:

-bash-3.00$ sqlplus /as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production

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

Usage 1: sqlplus -H | -V

-H             Displays the SQL*Plus version and the

usage help.

-V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [] [] [] ]

is: [-C ] [-L] [-M ""] [-R ] [-S]

-C    Sets the compatibility of affected commands to the

version specified by .  The version has

the form "x.y[.z]".  For example, -C 10.2.0

-L             Attempts to log on just once, instead of

reprompting on error.

-M "" Sets automatic HTML markup of output.  The options

have the form:

HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]

[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]

-R      Sets restricted mode to disable SQL*Plus commands

that interact with the file system.  The level can

be 1, 2 or 3.  The most restrictive is -R 3 which

disables all user commands interacting with the

file system.

-S             Sets silent mode which suppresses the display of

the SQL*Plus banner, prompts, and echoing of

commands.

is: ([/][@] | /)

[AS SYSDBA | AS SYSOPER] | /NOLOG

Specifies the database account username, password and connect

identifier for the database connection.  Without a connect

identifier, SQL*Plus connects to the default database.

The AS SYSDBA and AS SYSOPER options are database administration

privileges.

The /NOLOG option starts SQL*Plus without connecting to a

database.

is: @|[.] [ ...]

Runs the specified SQL*Plus script from a web server (URL) or the

local file system (filename.ext) with specified parameters that

will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile

(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile

(e.g. login.sql in the working directory) are run.  The files may

contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 15:54:53 2012

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

Connected to an idle instance.

SQL> alter user sys identified by 123;

alter user sys identified by 123

*

ERROR at line 1:

ORA-01034: ORACLE not available

SQL> select username from dba_users;

select username from dba_users

*

ERROR at line 1:

ORA-01034: ORACLE not available

SQL> quit

Disconnected

-bash-3.00$ id oracle

uid=205(oracle) gid=203(oinstall) groups=204(dba)

-bash-3.00$ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 27-AUG-2012 15:57:24

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /cdr2/app/oracle/product/10gr2/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production

System parameter file is /cdr2/app/oracle/product/10gr2/network/admin/listener.ora

Log messages written to /cdr2/app/oracle/product/10gr2/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdr2)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production

Start Date                27-AUG-2012 15:57:27

Uptime                    0 days 0 hr. 0 min. 2 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      ON

Listener Parameter File   /cdr2/app/oracle/product/10gr2/network/admin/listener.ora

Listener Log File         /cdr2/app/oracle/product/10gr2/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdr2)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "ocstest" has 1 instance(s).

Instance "ocstest", status UNKNOWN, has 1 handler(s) for this service...

Service "test62" has 1 instance(s).

Instance "test62", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-bash-3.00$ id

uid=205(oracle) gid=203(oinstall) groups=204(dba)

-bash-3.00$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 27-AUG-2012 15:58:31

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production

Start Date                27-AUG-2012 15:57:27

Uptime                    0 days 0 hr. 1 min. 5 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      ON

Listener Parameter File   /cdr2/app/oracle/product/10gr2/network/admin/listener.ora

Listener Log File         /cdr2/app/oracle/product/10gr2/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdr2)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "ocstest" has 1 instance(s).

Instance "ocstest", status UNKNOWN, has 1 handler(s) for this service...

Service "test62" has 1 instance(s).

Instance "test62", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 15:59:00 2012

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

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1610612736 bytes

Fixed Size                  2021224 bytes

Variable Size             318769304 bytes

Database Buffers         1275068416 bytes

Redo Buffers               14753792 bytes

Database mounted.

Database opened.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-bash-3.00$ env|grep ORACLE

ORACLE_SID=ocstest

ORACLE_BASE=/cdr2/app/oracle

ORACLE_HOME=/cdr2/app/oracle/product/10gr2

-bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 16:00:36 2012

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

SQL> connect /as sysdba

Connected.

SQL> select username from dba_users;