_exp FORMAT 990 HEADING i COLUMN parent_id_plus_exp FORMAT 990 HEADING p COLUMN plan_plus_exp FORMAT a60 COLUMN object_node_plus_exp FORMAT a8 COLUMN other_tag_plus_exp FORMAT a29 COLUMN other_plus_exp FORMAT a44
-- Default for XQUERY COLUMN result_plus_xquery HEADING 'Result Sequence'
set sqlprompt"_user'@'_connect_identifier>" "/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql" 49L, 1569C written
3.查看是否有user和连接的标识符。
[oracle@ocm1 ~]$ export ORACLE_SID=PROD [oracle@ocm1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:23:03 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
@>conn /as sysdba Connected to an idle instance. SYS@PROD>
#################################################################################################################### ORA-12162: TNS:net service name is incorrectly specified -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@ocm1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:21:30 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
@>conn /as sysdba ERROR: ORA-12162: TNS:net service name is incorrectly specified
指定ORACLE_SID=PROD即可 ####################################################################################################################
手动建库步骤：
1.创建密码文件
[oracle@ocm1 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/ [oracle@ocm1 dbs]$ ll total 28 -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora [oracle@ocm1 dbs]$
orapwd file=orapwPROD password=oracle entries=30 [oracle@ocm1 dbs]$ ll total 36 -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 5120 Apr 14 08:26 orapwPROD [oracle@ocm1 dbs]$
2.创建相关目录
[oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/admin/PROD/adump [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/admin/PROD/bdump [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/admin/PROD/cdump [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/admin/PROD/udump [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk1 [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk2/arch [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk3 [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk4 [oracle@ocm1 dbs]$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk5 [oracle@ocm1 dbs]$
3.创建pfile参数文件
[oracle@ocm1 dbs]$ pwd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm1 dbs]$
vi initPROD.ora
CONTROL_FILES=('/u01/app/oracle/oradata/PROD/Disk1/control01.ctl','/u01/app/oracle/oradata/PROD/Disk2/control02.ctl','/u01/app/oracle/oradata/PROD/Disk3/control03.ctl') DB_BLOCK_SIZE=8192 DB_CREATE_FILE_DEST=/u01/app/oracle/oradata/PROD/Disk1 DB_CREATE_ONLINE_LOG_DEST_1=/u01/app/oracle/oradata/PROD/Disk1 DB_NAME=PROD JOB_QUEUE_PROCESSES=10 LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/PROD/Disk2/arch' PROCESSES=200 SGA_TARGET=500M BACKGROUND_DUMP_DEST=/u01/app/oracle/admin/PROD/bdump CORE_DUMP_DEST=/u01/app/oracle/admin/PROD/cdump USER_DUMP_DEST=/u01/app/oracle/admin/PROD/udump UNDO_MANAGEMENT=auto UNDO_TA |