Oracle启动与停止命令

一：环境变量配置

export ORACLE_BASE=$HOME/app/oracle;

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1;

export ORACLE_SID=orcl;

export PATH=$ORACLE_HOME/bin:$PATH;

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH;

 

 

二：启动与停止

1、启动数据库：

oracle@suse92:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 135352820 bytes

Fixed Size 455156 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 679936 bytes

Database mounted.

2、关闭数据库：

oracle@suse92:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> shutdwon abort;

3、启动监听器

oracle@suse92:~> lsnrctl start

4、停止监听器

oracle@suse92:~> lsnrctl stop

5、查看监听器状态

oracle@suse92:~> lsnrctl

LSNRCTL> status

LSNRCTL> exit

6、gsmobile用户连接数据库：

sqlplus gsmobile/gsmobile@ORC

 

7、查询数据库名称

select name,dbid from v$database;

或者 show parameter db_name;

 

//sqlplus访问远程oracle ---具体请看另外一篇文章

修改环境变量

INSTANTCLIENT_HOME=$HOME/oci/instantclient_12_1

export ORACLE_HOME=$INSTANTCLIENT_HOME

export TNS_ADMIN=$INSTANTCLIENT_HOME

export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

export LD_LIBRARY_PATH=$INSTANTCLIENT_HOME:$LD_LIBRARY_PATH

PATH=$ORACLE_HOME:$INSTANTCLIENT_HOME:$PATH

 

8、方法一：sqlplus gsmobile/gsmobile@192.168.103.232:1521/ORC

ps:若是访问时出现ORA-12514: TNS:listener does not currently know of service requested in connect

注意ORC为数据库服务名称，查询服务名称命令select value from v$parameter where name = 'service_names'

 

9、方法二：sqlplus gsmobile/gsmobile@oraclegb

在TNS_ADMIN新建tnsnames.ora文件

oraclegb =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.103.232) (PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORC))