???ò????????
???????????? ???????[ 2014/8/18 11:31:17 ] ??????????????
?????????????????
????[oracle@mylinux admin]$ ll
????total 44
????-rw-r--r-- 1 oracle oinstall 279 Apr 5 20:12 listener1204058PM1243.bak
????-rw-r--r-- 1 oracle oinstall 752 Apr 10 22:29 listener.ora
????drwxr-xr-x 2 oracle oinstall 4096 Mar 13 05:32 samples
????-rw-r--r-- 1 oracle oinstall 187 May 9 2007 shrept.lst
????-rw-r--r-- 1 oracle oinstall 139 Apr 10 22:29 sqlnet.ora
????drwxr-xr-x 2 oracle oinstall 4096 Apr 8 20:24 temp
????-rw-r--r-- 1 oracle oinstall 298 Apr 5 20:12 tnsnames1204058PM1243.bak
????-rw-r----- 1 oracle oinstall 716 Apr 10 22:31 tnsnames.ora
????[oracle@mylinux admin]$ vi sqlnet.ora
??????sqlnet.ora?????????
????SQLNET.AUTHENTICATION_SERVICES=(NONE)
????[oracle@mylinux admin]$ sqlplus /nolog
????SQL*Plus: Release 11.2.0.1.0 Production on Thu May 17 20:58:07 2012
????Copyright (c) 1982?? 2009?? Oracle. All rights reserved.
????SQL> conn /as sysdba
????ERROR:
????ORA-01031: insufficient privileges
????SQL> conn sys/oracle as sysdba
????ERROR:
????ORA-01017: invalid username/password; logon denied
????--?????????????????????????
??????sqlnet.ora?е?SQLNET.AUTHENTICATION_SERVICES=(NONE)??????
????SQL> conn /as sysdba
????Connected.
????SQL> show parameter remote_login_passwordfile;
????NAME TYPE VALUE
????------------------------------------ ----------- ------------------------------
????remote_login_passwordfile string NONE
????--???????????????????????????????????????????????????(remote_login_passwordfile?none)
????SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;
????System altered.
???????????
???????sqlnet.ora???SQLNET.AUTHENTICATION_SERVICES=(NONE)
????[oracle@mylinux admin]$ sqlplus /nolog
????SQL*Plus: Release 11.2.0.1.0 Production on Thu May 17 21:02:53 2012
????Copyright (c) 1982?? 2009?? Oracle. All rights reserved.
????SQL> conn /as sysdba
????ERROR:
????ORA-01031: insufficient privileges
????SQL> conn sys/oracle as sysdba
????Connected.
?????????
????sqlnet.ora?е?SQLNET.AUTHENTICATION_SERVICES=(NONE)?????????ò??????????
?????????????????????????ú????????????е????????????????????ops$??Щ????????????????
????????remote_login_passwordfile???????????????none????????????????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11