CentOS7下安装Oracle12c后的一些相关工作

来源：互联网发布：js写日历编辑：程序博客网时间：2024/06/05 11:39

主要参考这篇文章：CentOS7下安装Oracle12c方法

这篇文章中讲的是在linux下如何安装Oracle12c数据库
，然后我这里记录一下，我的环境变量：

# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/binexport PATH################################ 定义oracle的相关环境变量 ################################export ORACLE_BASE=/home/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1export ORACLE_OWNER=oracleexport ORACLE_SID=orclexport ORACLE_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/jlibexport NLS_LANG=AMERICAN_AMERICA.UTF8[oracle@localhost ~]$

还有记录一下如何在客户端去配置访问服务器的Oracle数据库，

前面根据文章首先建立好一个数据库ORCL，然后为其创建监听 ORCL，并且创建号用户，和为其授权等

然后把文件network/admin/tnsnames.ora

[oracle@localhost admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCLPDB =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.200.239)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )LISTENER_ORCL =  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )[oracle@localhost admin]$

copy到客户端的配置文件中，然后打开plsql，编辑 plsql配置

0 0