oracle 修改服务名服务名,修改数据库名(db_name)及实例名(Instance_name or Service_name)...

SQL>> Oracle Database 12c Enterprise Edition Release .. -~]$ sed -i s///g  ~/~]$ source ~/~]$ env |=~]$ mv $ORACLE_HOME/dbs/spfilescp.ora $ORACLE_HOME/dbs/~]$ sqlplus *Plus: Release .. Production on Wed May  :: , >>------------------------------------ ----------- ------------------------------     ETDB

SQL>

alter system register;    --向listener注册

System altered.

SQL>

host lsnrctl reload;

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-MAY-2016 23:52:04

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg1)(PORT=1521)))

The command completed successfully

SQL>

host lsnrctl status;

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-MAY-2016 23:52:10

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg1)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date                25-MAY-2016 23:14:06

Uptime                    0 days 0 hr. 38 min. 4 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/dg1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg1.zytk.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ETDB" has 1 instance(s).

Instance "etdb", status READY, has 1 handler(s) for this service...

Service "scpXDB" has 1 instance(s).

Instance "etdb", status READY, has 1 handler(s) for this service...

The command completed successfully