- 精华
- 阅读权限
- 30
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2011-6-7
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
我是照着演示视频跟文字说明装的,前面遇到的无法连接secureCRT已经解决,但是在oracle启动部分又出现了问题,在文字说明中“349360167 //注意,这里输入密码的时候终端上面是不显示的,不过确实输入到里面去了,你直接输入后直接回车即可。”这一步的下面是“sqlplus sys/349360167@orcl as sysdba”,而在视频中,输入的是“sqlplus sys/349360167@orcl as sysdba”,可是不管我输入哪一个,出现的信息都跟视频中的不一样,按照视频中的输法,出现的是:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 9 20:29:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
按照文字中的输法,出现的是:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 9 20:33:04 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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 [ [<option>] [<logon>] [<start>] ]
<option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]
-C <version> Sets the compatibility of affected commands to the
version specified by <version>. 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 "<options>" 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 <level> 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.
<logon> is: (<username>[/<password>][@<connect_identifier>] | /)
[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.
<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
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.
现在我不知道该怎么进行下去了,有哪位高人指导下吗,谢谢了 |
|