远程连接oracle01017,sqlplus远程sys用户登录ora 01017的解决方法
大家好,又见面了,我是你们的朋友全栈君。
Using ORAPWD
When you invoke this password file creation utility without supplying any parameters, you receive a message indicating the proper use of the command as shown in the following sample output:
> orapwd
Usage: orapwd file=password=entries=force=where
file – name of password file (mand),
password – password for SYS (mand),
entries – maximum number of distinct DBAs and OPERs (opt),
force – whether to overwrite existing file (opt)
There are no spaces around the equal-to (=) character.
The following command creates a password file named acct.pwd that allows up to 30 privileged users with different passwords. In this example, the file is initially created with the password secret for users connecting as SYS.
orapwd FILE=acct.pwd PASSWORD=secret ENTRIES=30
The parameters in the ORAPWD utility are described in the sections that follow.
FILE
This parameter sets the name of the password file being created. You must specify the full path name for the file. The contents of this file are encrypted, and the file cannot be read directly. This parameter is mandatory.
The types of filenames allowed for the password file are operating system specific. Some operating systems require the password file to adhere to a specific format and be located in a specific directory. Other operating systems allow the use of environment variables to specify the name and location of the password file. For name and location information for the Unix and Linux operating systems, see Administrator’s Reference for UNIX-Based Operating Systems. For Windows, see Platform Guide for Microsoft Windows. For other operating systems, see your operating system documentation.
If you are running multiple instances of Oracle Database using Oracle Real Application Clusters, the environment variable for each instance should point to the same password file.
Caution:
It is critically important to the security of your system that you protect your password file and the environment variables that identify the location of the password file. Any user with access to these could potentially compromise the security of the connection.
PASSWORD
This parameter sets the password for user SYS. If you issue the ALTER USER statement to change the password for SYS after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. This parameter is mandatory.
Note:
You cannot change the password for SYS if REMOTE_LOGIN_PASSWORDFILE is set to SHARED. An error message is issued if you attempt to do so.
ENTRIES
This parameter specifies the number of entries that you require the password file to accept. This number corresponds to the number of distinct users allowed to connect to the database as SYSDBA or SYSOPER. The actual number of allowable entries can be higher than the number of users, because the ORAPWD utility continues to assign password entries until an operating system block is filled. For example, if your operating system block size is 512 bytes, it holds four password entries. The number of password entries allocated is always a multiple of four.
Entries can be reused as users are added to and removed from the password file. If you intend to specify REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE, and to allow the granting of SYSDBA and SYSOPER privileges to users, this parameter is required.
Caution:
When you exceed the allocated number of password entries, you must create a new password file. To avoid this necessity, allocate a number of entries that is larger than you think you will ever need.
FORCE
This parameter, if set to Y, enables you to overwrite an existing password file. An error is returned if a password file of the same name already exists and this parameter is omitted or set to N.
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/138035.html原文链接:https://javaforall.cn
相关文章
- 使用pycharm连接MySQL数据库的方法「建议收藏」
- 修复未能连接一个window服务器,未能连接一个windows服务的修复方法
- oracle 19c ora-01017,Oracle 19c RMAN 连接PDB ORA-01017 错误解决方法
- 关于putty连接服务器提示server unexpectedly closed connection解决方法「建议收藏」
- oracle连接出现ora-12154,与虚拟机Oracle连接出现ora-12154问题的解决方法
- plsql连接oracle数据库报ora 12154错误解决方法
- 【说站】java线程池关闭的方法
- vue父子组件传值方法_vue父组件向子组件传递对象
- Vue中websocket的使用方法
- Redis禁用命令、危险命令及规避方法
- 与虚拟机Oracle连接出现ora-12154问题的解决方法
- java操作文件FileUtil文件相关的工具类常用方法详解编程语言
- 文件Linux快速删除tar文件的方法(linux删除tar)
- JSP Request.removeAttribute()方法:删除请求中的一个属性
- 探索Linux系统中查看连接用户的方法(linux查看连接的用户)
- 简易指南:Oracle连接技术入门(oracle连接方法)
- 使用VC连接Oracle数据库的有效方法(vc连接oracle)
- MySQL日期序列生成方法(mysql日期序列)
- PHP无法连接MSSQL数据库问题的解决方法(php 无法 mssql)
- MySQL中使用for循环语句的方法及应用场景(mysql中for循环)
- 本地Redis连接失败排查原因与解决方法(本地的redis连不上)
- 深入了解mysqlping函数的使用方法和示例(mysql_ping实例)
- asp.net动态载入用户控件的方法
- jbuilder2006连接sqlserver2000的方法
- 连接到txt文本的超链接,不直接打开而是点击后下载的处理方法
- PHP连接MSSQL时nvarchar字段长度被截断为255的解决方法
- php购物车实现方法