when execute expdp we lost one service on service_names parameter (RAC 11.2.0.4)
Hi friends, when we execute this:
oracle@bcn1-db-oracle-1$ expdp admin tables=table_1 directory=.... | < |
Export: Release 11.2.0.4.0 - Production on Fri Jul 29 10:16:08 2016
.
.
. . exported table_1 | 3.633 MB | 6257 rows |
Master table "ADMIN"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
In the alert log of this instance:
ALTER SYSTEM SET service_names='prim_db',.....
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_1_20160729101614.EDREAL','prim_db'..... |
But service prim_db dissapear from parameter service_names!!
In the v$active services and in the cluster:
SQL> select name from v$active_services order by 1;
prim_db
.
.
oracle@bcn1-db-oracle-105p1:~$ crsctl stat res -t |
--------------------------------------------------------------------------------
Cluster Resources