加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 综合聚焦 > 服务器 > 安全 > 正文

bash – sqlplus / nolog输出–help和exiting`

发布时间:2020-12-15 20:54:55 所属栏目:安全 来源:网络整理
导读:更新:它在cmd中工作,当我从bash客户端运行cmd时.仍然喜欢它在git bash中工作,但我有一个解决方法. 我试图在Windows上的git bash客户端运行sqlplus / nolog命令.但是,当我运行该命令时,它会启动一个会话,显示信息就好像我键入了sqlplus –help然后退出.我可
更新:它在cmd中工作,当我从bash客户端运行cmd时.仍然喜欢它在git bash中工作,但我有一个解决方法.

我试图在Windows上的git bash客户端运行sqlplus / nolog命令.但是,当我运行该命令时,它会启动一个会话,显示信息就好像我键入了sqlplus –help然后退出.我可以远程进入我们的一个Linux服务器并按预期在那里运行命令,但我不能让它在本地工作.

我没有glogin.sql文件.

我需要做什么才能使sqlplus / nolog命令按预期工作?

user@computer ~/currentLocation
$sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 26 09:19:45 2017

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


SQL*Plus: Release 12.1.0.2.0 Production

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

Use SQL*Plus to execute SQL,PL/SQL and SQL*Plus statements.

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 | /nolog}] [<start>] ]

  <option> is: [-C <version>] [-L] [-M "<options>"] [-NOLOGINTIME] [-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}]
    -NOLOGINTIME   Don't display Last Successful Login Time.
    -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 | SYSOPER | SYSASM | SYSBACKUP | SYSDG | SYSKM}] [EDITION=value]

    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,AS SYSOPER,AS SYSASM,AS SYSBACKUP,AS SYSDG,and AS SYSKM options are database administration privileges.

    <connect_identifier> can be in the form of Net Service Name
    or Easy Connect.

      @[<net_service_name> | [//]Host[:Port]/<service_name>]

        <net_service_name> is a simple name for a service that resolves
        to a connect descriptor.

        Example: Connect to database using Net Service Name and the
                 database net service name is ORCL.

           sqlplus myusername/mypassword@ORCL

        Host specifies the host name or IP address of the database
        server computer.

        Port specifies the listening port on the database server.

        <service_name> specifies the service name of the database you
        want to access.

        Example: Connect to database using Easy Connect and the
                 Service name is ORCL.

           sqlplus myusername/mypassword@Host/ORCL

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

    The EDITION specifies the value for Session Edition.


  <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.

解决方法

刚遇到同样的问题,找到了你的帖子.请改用此命令: ????sqlplus // nolog

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读