博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
创建外部用户_外部表
阅读量:6945 次
发布时间:2019-06-27

本文共 3941 字,大约阅读时间需要 13 分钟。

[root@localhost ~]# su - oracle[oracle@localhost ~]$ sqlplus /  sysdba;*Plus: Release 11.2.0.3.0 Production  Fri Jul 13 22:22:59 2018Copyright (c) 1982, 2011, Oracle.   rights reserved.Connected :Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing optionsSYS@orcl>  instance_name ,status  v$instance;INSTANCE_NAME    STATUS---------------- ------------orcl             SYS@orcl> quitDisconnected  Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing options[oracle@localhost ~]$ logout[root@localhost ~]# who am iroot     pts/10       2018-07-13 22:22 (192.168.242.1)[root@localhost ~]#  useradd oracleexternal[root@localhost ~]# passwd oracleexternalChanging password   oracleexternal.New UNIX password:Retype new UNIX password:passwd:  authentication tokens updated successfully.[root@localhost ~]# su - oracleexternal[oracleexternal@localhost ~]$ cat .bash_profile# .bash_profile#  the aliases  functions [ -f ~/.bashrc ];         . ~/.bashrcfi#  specific environment  startup programsPATH=$PATH:$HOME/binexport PATH[oracleexternal@localhost ~]$ vi .bash_profile# .bash_profile#  the aliases  functions [ -f ~/.bashrc ];         . ~/.bashrcfi#  specific environment  startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib~~~~~~".bash_profile" 20L, 479C written[oracleexternal@localhost ~]$ cat .bash_profile# .bash_profile#  the aliases  functions [ -f ~/.bashrc ];         . ~/.bashrcfi#  specific environment  startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib[oracleexternal@localhost ~]$  source .bash_profile[oracleexternal@localhost ~]$ su - oraclePassword:[oracle@localhost ~]$ rlwrap sqlplus /  sysdba;*Plus: Release 11.2.0.3.0 Production  Fri Jul 13 22:25:45 2018Copyright (c) 1982, 2011, Oracle.   rights reserved.Connected :Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing optionsSYS@orcl> show parameter osNAME                                 TYPE        ------------------------------------ ----------- ------------------------------db_lost_write_protect                string      diagnostic_dest                      string      /u01/app/oracleoptimizer_index_cost_adj                  100os_authent_prefix                    string      ops$os_roles                             boolean     remote_os_authent                    boolean     remote_os_roles                      boolean     timed_os_statistics                       0SYS@orcl>   ops$oracleexternal identified externally; created.SYS@orcl>     ops$oracleexternal; succeeded.SYS@orcl> quitDisconnected  Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing options[oracle@localhost ~]$ logout[oracleexternal@localhost ~]$ who am[oracleexternal@localhost ~]$ whoamioracleexternal[oracleexternal@localhost ~]$ sqlplus /*Plus: Release 11.2.0.3.0 Production  Fri Jul 13 22:27:16 2018Copyright (c) 1982, 2011, Oracle.   rights reserved.Connected :Oracle  11g Enterprise Edition Release 11.2.0.3.0 - Production the Partitioning, OLAP, Data Mining   Application Testing optionsOPS$ORACLEEXTERNAL@orcl>OPS$ORACLEEXTERNAL@orcl>    ;22:29:13 OPS$ORACLEEXTERNAL@orcl>

转载于:https://www.cnblogs.com/ios9/p/9307752.html

你可能感兴趣的文章
UVa10561 Treblecross
查看>>
windbg 调试提示sos与clr不匹配问题
查看>>
剑指offer:数据流中的中位数
查看>>
JS调用命令实现F11全屏
查看>>
a标签href无值,点击刷新页面解决办法
查看>>
Arm开发板+Qt学习之路
查看>>
unknown local index 'index_name' in search request
查看>>
看视频学编程之C#中的类
查看>>
C# DataGridView控件绑定数据后清空数据
查看>>
C++基础知识(一)
查看>>
高抬贵手,拉耳复阳
查看>>
win2003 iis6 iis假死
查看>>
计算机网络知识总结
查看>>
poj 3844 Divisible Subsequences 剩余类,组合计数
查看>>
响应式布局这件小事
查看>>
子窗口访问父页面iframe中的iframe,top打开的子窗口访问父页面中的iframe中的iframe...
查看>>
css属性设置
查看>>
MongoDB -- JAVA基本API操作
查看>>
maven-reportng插件依赖添加
查看>>
树的存储结构实例
查看>>