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

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

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

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

##############################
## 定义oracle的相关环境变量 ##
##############################
export ORACLE_BASE=/home/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export ORACLE_PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export 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，编辑

转载于:https://my.oschina.net/junehappylove/blog/853854