How to Remote Access Oracle DB
来源:互联网 发布:oracle sql修改字段名 编辑:程序博客网 时间:2024/05/29 23:45
When you install Oracle DB, the default hostname is localhost. However, we cannot access this DB by other hosts. So how to config to help the remote visitors to access the ODB.
What we need to do is to change the hostname of ODB in Linux.
So first, we need to login our host and go to the path of Oracle DB home.
Under the path of DB, go to the network / admin, we can find listener.ora and tnsnames.ora these two files. The host info is stored in these files.
Go into these two files to change the value of hostname and value of service name.
After do --- vim listener.ora, we need to modify HOST value from localhost to your host address.
After do -- vim tnsnames.ora, the value of HOST and SERVICE_NAME.
After we exit from vim, we have to open the DB server listener.
Go to the bin folder under dbhome_1, do-- setenv ORACLE_HOME (dbhome_1 pwd)
-- setenv ORACLE_SID orcl
Under bin folder, we can run sqlplus and lsnrctl to verify the DB listener is open.
When the status of listener is open, that means other host can access this host DB. Right now you can use sql developer to try it. GOOD LUCK!!
- How to Remote Access Oracle DB
- How to access remote mysql
- how to logon Oracle DB
- How Do I Enable Remote Access To MySQL Database Server?
- Remote Access To MySQL
- How to configure ODBC DSN in Client to access remote DB2 for Windows
- How to access to remote server by root directly on solaris
- How to start/stop DB instance of Oracle under Linux
- Liferay 7 CE: How to add support for Oracle DB
- How to use Chrome to access Oracle Applications
- How to access a Window XP Remote Destop in a ipv6 network
- UWP(2) How to access the Sqlite db(如何访问Sqlite数据库文件)
- How To Install Berkeley DB
- How to read settings.db
- How to Add Route to TCP/IP Routing Table With Windows Routing And Remote Access Console or DOS Promp
- AWS RDS Oracle DB remote connection
- Google software allows remote access to PCs
- Remote Access to the Fedora Linux Desktop
- 上课吗浪费点卡上课了陌生地方立刻马上发的了看离开发多少离开的方式
- java中的多线程
- redis-cluster安装和配置
- MYSQL--事务处理
- 雏鹅饲养小经验
- How to Remote Access Oracle DB
- 接口和抽象类有什么区别
- 百度地图使用教程(Javascript版)
- R语言数据操作基础
- OpenCV中矩阵与列向量的互相转换
- TCP协议中的三次握手和四次挥手(图解)
- C语言_数组
- Junit详解
- uva10125Sumsets