乐山网站建设

专注高端品牌网站建设行业优质供应商！认准小谭建站！
028-86922220135-1821-9792
  • 首页
  • 网站建设
    网站设计包含服务 网站制作流程 有效沟通方式 售后服务
  • 微信开发
  • 案例展示
    乐山小谭建站公司作品案例展示
  • 新闻资讯
  • 解决方案
  • 小谭建站
  • 联系我们

    • 【方法】Oracle用户密码含特殊字符时的登陆问题-创新互联

    【方法】Oracle用户密码含特殊字符时的登陆问题

    成都创新互联主要从事成都做网站、网站制作、成都外贸网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务港南,10余年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:028-86922220

    1.1  BLOG文档结构图

    【方法】Oracle用户密码含特殊字符时的登陆问题

    1.2.2  相关文章链接

     【密码】Oracle用户密码系列：http://blog.itpub.net/26736162/viewspace-2129595/

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

    第二章 实验部分

    2.1  实验环境介绍

    项目

    source db

    db类型

    RAC

    db version

    11.2.0.3.0

    db存储

    ASM

    OS版本及kernel版本

    RHEL 6.5

    2.2  实验目标

    当用户密码含有特殊字符的时候，测试sqlplus和exp、imp及expdp、impdp的登陆及修改密码问题。

    2.3  实验过程

    2.3.1  sqlplus连接

    普通用户连接：

    [oracle@orcltest admin]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 24 09:25:35 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SYS@lhrdb>alter user lhr identified by "l@hr";

    User altered.

    SYS@lhrdb> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    [oracle@orcltest ~]$sqlplus 'lhr/"l@hr"'@LHRDB

    SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 24 09:27:05 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    LHR@LHRDB> EXIT

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    [oracle@orcltest ~]$

    sys用户连接：

    [oracle@orcltest admin]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 24 09:29:09 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SYS@lhrdb> alter user sys identified by "l@hr";

    User altered.

    SYS@lhrdb> exit

    [oracle@orcltest ~]$sqlplus 'sys/"l@hr"'@LHRDB as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 24 09:29:35 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SYS@LHRDB> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    [oracle@orcltest ~]$

    2.3.2  expdp连接

    密码用双引号，用户名和密码用单引号括起来，然后【用户名】+【密码】+【tn】+【as sysdba】用单引号括起来，最后的这个单引号用\进行转义

    expdp \''sys/"l@hr"'@LHRDB as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFILE=SCOTT%U.dmp SCHEMAS=SCOTT COMPRESSION=all metrics=y

    [oracle@orcltest admin]$ expdp \''sys/"l@hr"'@LHRDB as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFILE=SCOTT%U.dmp SCHEMAS=SCOTT COMPRESSION=all metrics=y

    Export: Release 11.2.0.3.0 - Production on Fri Feb 24 09:32:22 2017

    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    FLASHBACK automatically enabled to preserve database integrity.

    Starting "SYS"."SYS_EXPORT_SCHEMA_01": "sys/********@LHRDB AS SYSDBA" DIRECTORY=DATA_PUMP_DIR DUMPFIL

    Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

        Completed 4 TABLE_STATISTICS objects in 14 seconds

    . . exported "SCOTT"."DEPT"                             4.976 KB      4 rows

    . . exported "SCOTT"."EMP"                              5.617 KB     14 rows

    . . exported "SCOTT"."SALGRADE"                         4.890 KB      5 rows

    . . exported "SCOTT"."BONUS"                                0 KB      0 rows

    Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

    ******************************************************************************

    Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

     /u02/app/oracle/admin/lhrdb/dpdump/SCOTT01.dmp

    Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 09:33:19

    2.3.3  修改密码中含有“@”符号

    [oracle@orcltest ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 16 17:10:26 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SYS@lhrdb> alter user scott identified by "tiger&123";

    Enter value for 123:

    old  1: alter user scott identified by "tiger&123"

    new  1: alter user scott identified by "tiger"

    User altered.

    SYS@lhrdb>

    SYS@lhrdb>set define off

    SYS@lhrdb>alter user scott identified by "tiger&123";

    User altered.

    SYS@lhrdb> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    [oracle@orcltest ~]$ sqlplus 'scott/"tiger&123"'@LHRDB

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 16 17:14:00 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SCOTT@LHRDB>

    SCOTT@LHRDB>set define off

    SCOTT@LHRDB>alter user scott identified by "$tiger&123l@h\r/0%s,d$";

    User altered.

    SCOTT@LHRDB> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    [oracle@orcltest ~]$ sqlplus 'scott/"$tiger&123l@h\r/0%s,d$"'@LHRDB

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 16 17:20:12 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SCOTT@LHRDB>

    2.3.4  修改密码中含有双引号符号

    修改scott用户的密码为：a"b

    [oracle@orcltest ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 16 17:39:18 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SYS@lhrdb> password scott

    Changing password for scott

    New password:

    Retype new password:

    Password changed

    SYS@lhrdb> conn scott/a"b

    Connected.

    SCOTT@lhrdb>

    [oracle@orcltest ~]$ sqlplus scott/a\"b

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 16 17:42:34 2017

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

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Data Mining

    and Real Application Testing options

    SCOTT@lhrdb>

    注：因为一般特殊字符可以使用双引号处理，但是如果密码中含有双引号，就不能用双引号处理，可以直接使用password修改密码。

    2.4  本文结论

    参考下表：

    【方法】Oracle用户密码含特殊字符时的登陆问题

    Linux平台

    sqlplus工具

    数据泵工具（exp、expdp）

    普通用户

    无tns

    sqlplus 'lhr/"l@h\r/0"'

    expdp 'lhr/"l@h\r/0"'

    有tns

    sqlplus 'lhr/"l@h\r/0"'@LHRDB

    expdp 'lhr/"l@h\r/0"'@LHRDB

    sys用户

    无tns

    sqlplus / as sysdba

    expdp \'/ AS SYSDBA\'

    有tns

    sqlplus 'sys/"l@h\r/0"'@LHRDB as sysdba

    expdp \''sys/"l@h\r/0"'@LHRDB as sysdba\'

    正常密码

    sqlplus sys/lhr@lhrdb as sysdba

    expdp \'sys/lhr@LHRDB as sysdba\'

    备注：含特殊字符密码为：l@h\r/0，正常密码为：lhr，tns为：LHRDB，总的原则为：密码用双引号括起来，用户名和密码用单引号括起来，然后【用户名】+【密码】+【tns】+【as sysdba】用单引号括起来，最后的这个单引号用\进行转义

    alter user lhr identified by "l@h\r/0";

    alter user sys identified by "l@h\r/0";

    set define off

    alter user scott identified by "$tiger&123l@h\r/0%s,d$";

    alter user scott identified by "$?`$%*H\@f'\`}:H$";

    password scott

    Windows平台

    sqlplus工具

    数据泵工具（exp、expdp）

    普通用户

    无tns

    sqlplus lhr/"""l@h\r/0"""

    sqlplus lhr/\"l@h\r/0\"

    expdp lhr/"""l@h\r/0"""

    expdp lhr/\"l@h\r/0\"

    有tns

    sqlplus lhr/"""l@h\r/0"""@LHRDB

    sqlplus lhr/\"l@h\r/0\"@LHRDB

    expdp lhr/"""l@h\r/0"""@LHRDB

    expdp lhr/\"l@h\r/0\"@LHRDB

    sys用户

    无tns

    sqlplus / as sysdba

    expdp \"/ as sysdba\"

    有tns

    sqlplus sys/"""l@h\r/0"""@LHRDB as sysdba

    sqlplus sys/\"l@h\r/0\"@LHRDB as sysdba

    正常密码

    sqlplus sys/lhr@lhrdb as sysdba

    expdp \"sys/lhr@LHRDB as sysdba\"

    备注：含特殊字符密码为：l@h\r/0，正常密码为：lhr，tns为：LHRDB，总的原则为：密码用3个双引号括起来，或者用一个双引号括起来，然后用\将双引号进行转义  DIRECTORY=DATA_PUMP_DIR DUMPFILE=dmp_SCOTT.dmp SCHEMAS=SCOTT reuse_dumpfiles=y

    About Me

    ...............................................................................................................................

    ●本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用

    ●本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）和个人微信公众号（xiaomaimiaolhr）上有同步更新

    ●本文itpub地址：http://blog.itpub.net/26736162/viewspace-2135493/

    ●本文博客园地址：http://www.cnblogs.com/lhrbest/p/6560906.html

    ●本文pdf版及小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/

    ● QQ群：230161599    微信群：私聊

    ●联系我请加QQ好友(642808185)，注明添加缘由

    ●于2017-03-16 10:00 ~ 2017-03-16 22:00 在泰兴公寓完成

    ●文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解

    ●版权所有，欢迎分享本文，转载请保留出处

    ...............................................................................................................................

    拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号：xiaomaimiaolhr，扫描右边的二维码加入小麦苗的QQ群，学习最实用的数据库技术。

    【方法】Oracle用户密码含特殊字符时的登陆问题【方法】Oracle用户密码含特殊字符时的登陆问题

       【方法】Oracle用户密码含特殊字符时的登陆问题

    另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。


    文章题目：【方法】Oracle用户密码含特殊字符时的登陆问题-创新互联
    文章URL：http://lszwz.com/article/jhhhe.html

    其他资讯

    售后响应及时

    7×24小时客服热线

    数据备份

    更安全、更高效、更稳定

    价格公道精准

    项目经理精准报价不弄虚作假

    合作无风险

    重合同讲信誉，无效全额退款

    联系我们

    TEL

    135-1821-9792

    028-86922220

    地址：乐山市太升南路288号锦天国际

    快捷导航

    Shortcut

    二维码

    QR CODE

    • 微信公众号

    • 手机端网站

    乐山小谭建站工作室是一家专注从事于高品质视觉体验及互联网设计开发，乐山网站建设，乐山网站设计，乐山网页设计，乐山网站制作，品牌网站建设，营销网站建设，集团网站建设，企业网站建设，外贸网站建设，响应式网站建设，小程序开发，微信开发，企业形象设计，企业宣传视频等服务，小谭建站位于乐山市龙岗区大运软件小镇，小谭建站拥有经验丰富的高级网站建设工程师和一流的网页高端设计人员，具备各种规模与类型网站建设的雄厚实力，在网站建设领域树立了自己独特的设计风格。
    友情链接 交换友情链接
    鳄鱼养殖   成都网站推广   快照排名   乐山主机托管   四川成都托管服务器   SSL证书   帛金家居   企业网站设计   成都服务器托管   响应式报价   

    Copyright © 2022 青羊区小谭信息技术咨询服务工作室 乐山建站工作室 All Rights Reserved   蜀ICP备2021004003号-25

    Copyright © 2022 青羊区小谭信息技术咨询服务工作室 乐山建站工作室 

    蜀ICP备2021004003号-25