su - oracle
. oraenv
lis
sqlplus / as sysdba
shutdwon immediate;
startup
第五步:如果是启动服务,要开启监听
退出sqlplus模式,输入
lsnrctl start
SQL> select status from v$instance;
怎么查看centos的oracle装在哪里了
which sqlplus
find / -name sqlplus
su - oracle
set|grep ORACLE_HOME.
expdp user/password@127.0.0.1:1521/orcl directory=expdp_dir dumpfile=HRP%date%%time%.DMP logfile=HRP%date%%time%.LOG schemas=kttest2