内射老阿姨1区2区3区4区_久久精品人人做人人爽电影蜜月_久久国产精品亚洲77777_99精品又大又爽又粗少妇毛片

【方法】Oracle用戶密碼含特殊字符時的登陸問題-創(chuàng)新互聯(lián)

【方法】Oracle用戶密碼含特殊字符時的登陸問題

成都創(chuàng)新互聯(lián)主要從事成都做網(wǎng)站、網(wǎng)站制作、成都外貿(mào)網(wǎng)站建設、網(wǎng)頁設計、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務。立足成都服務港南,10余年網(wǎng)站建設經(jīng)驗,價格優(yōu)惠、服務專業(yè),歡迎來電咨詢建站服務:028-86922220

1.1  BLOG文檔結構圖

【方法】Oracle用戶密碼含特殊字符時的登陸問題

1.2.2  相關文章鏈接

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

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

第二章 實驗部分

2.1  實驗環(huán)境介紹

項目

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工具

數(shù)據(jù)泵工具（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'\<a-q $-@#<="">`}:H$";

password scott

Windows平臺

sqlplus工具

數(shù)據(jù)泵工具（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

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

●本文作者：小麥苗，只專注于數(shù)據(jù)庫的技術，更注重技術的運用

●本文在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    微信群：私聊

●聯(lián)系我請加QQ好友(642808185)，注明添加緣由

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

●文章內(nèi)容來源于小麥苗的學習筆記，部分整理自網(wǎng)絡，若有侵權或不當之處還請諒解

●版權所有，歡迎分享本文，轉載請保留出處

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

拿起手機使用微信客戶端掃描下邊的左邊圖片來關注小麥苗的微信公眾號：xiaomaimiaolhr，掃描右邊的二維碼加入小麥苗的QQ群，學習最實用的數(shù)據(jù)庫技術。

【方法】Oracle用戶密碼含特殊字符時的登陸問題【方法】Oracle用戶密碼含特殊字符時的登陸問題

   【方法】Oracle用戶密碼含特殊字符時的登陸問題

另外有需要云服務器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。

標題名稱：【方法】Oracle用戶密碼含特殊字符時的登陸問題-創(chuàng)新互聯(lián)
瀏覽地址：http://www.rwnh.cn/article44/jhhhe.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供ChatGPT、網(wǎng)站策劃、網(wǎng)站建設、App開發(fā)、外貿(mào)建站、外貿(mào)網(wǎng)站建設

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)

搜索引擎優(yōu)化
普陀区| 建昌县| 铅山县| 石林| 民权县| 夏津县| 美姑县| 敦煌市| 章丘市| 称多县| 凤翔县| 江门市| 垣曲县| 宁远县| 察雅县| 遵义县| 仲巴县| 万宁市| 武穴市| 大同县| 柏乡县| 南平市| 葵青区| 瓦房店市| 鲜城| 彭泽县| 民丰县| 金华市| 阿坝| 南召县| 宜春市| 桃源县| 凤庆县| 宁化县| 玉门市| 志丹县| 渝中区| 璧山县| 吉首市| 沛县| 巴马|