Database - RAC/Scalability (MOSC)

MOSC Banner

when execute expdp we lost one service on service_names parameter (RAC 11.2.0.4)

edited Aug 1, 2016 11:07PM in Database - RAC/Scalability (MOSC) 2 commentsAnswered ✓

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 MB6257 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center