In my alert log, it shows like below
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_1_254872100321.halimdb.halimdba.COM','halimdbservice' SCOPE=MEMORY SID='halimdb1';
why it shows this command, i am sure nobody can execute this command in this Database.
so how it appear in alert log.
Answer:-
You must have run expdp or impdp recently. These tools change the service name.
Datapump doesn't tamper with existing services, it just creates
new services for its own queue operation.
You can also find similar statement in the alert log file after running the expdp command.
just test it .
2 comments:
Hello everyone
I'm shahin and very interested to learn Oracle Database. I'm not interested to do it in a institution but with personally from any expert DBA.
If anybody is kind and have time to help me, please leave a message to me.
Email : shahinkazi1@gmail.com
Cell : 01718699590
web site : http://kazishahin.com
i m using datapump on my production database daily. but i didn't see any message like alter system set service_names,
i using 10g and 11g
Post a Comment