Sunday, June 10, 2018

Oracle Database Resource Portfolio - Support Tools

Oracle Database Resource Portfolio - Support Tools

Support Tools 
Diagnosability Framework
Since DB 11g, trace files relevant to a critical database incidents are stored in the Automatic Diagnostic Repository (ADR). Using ADRCI (ADR Command Interpreter) or the Support Workbench, customers can package the files specific to the incident via the Incident Packaging Service (IPS) . All they need is run a command to package the incident corresponding diagnostics and upload the package through My Oracle Support (MOS) to the SR. The package will include the alert log and all the relevant trace files related to the incident.

With DB 12c, improvements focus is on  first failure diagnostics for database components, not just critical issues. Notes covering changes in the major product areas will be incorporated in notes to be listed here.
Troubleshooting Tools
Troubleshooting tools provide recommendations to resolve common issues by analyzing uploaded files. When a known solution is available, the tool will display the symptoms and causes which can lead to the issue and one or more suggestions for resolving the issue.
Benefits of using the Troubleshooting Tools:
  • Analyzes uploaded files to provide recommendations when a known solution is available
  • Troubleshooting report can be saved for later use
  • Diagnostic Guide is available
  • Create SR option available which will automatically populate many of the SR fields
Troubleshooting Assistants
"Assistants" are created by Oracle Support helping you to find KM documents that will meet specified symptoms.
Instead of typing the symptoms into our Knowledge Search engine, the Assistant presents a list of symptoms to choose from for a certain topic. Once the symptom is selected, the Assistant then engages in a dialogue and presents further options to the user to select from in order to clarify the issue and/or errors.

Data Collection Tools
Data Collection tools provide an easy user interface for capturing data and helping with issue diagnosis.  

 Monitoring Tools
Monitoring Tools assist with capturing and observing performance metrics for your environment including database, operating system etc.
 Health Checks / Verification
 Health Checks and Verification tools can alert you about a potential issue before the issue actually occurs.


at No comments:
Labels: , , , , , , ,

Oracle Database Resource Portfolio - Getting Started

This index provides a single, easy-to-navigate comprehensive library of Oracle Database resources. Quickly and easily access the latest alerts, news, best practices, health checks, tools, recommended communities, and troubleshooting information.

Stay Informed


Stay Connected


Get Accredited


Support Policies

Webcasts

at No comments:
Labels: ,

Saturday, June 9, 2018

Common Interview Question and Answers


Tell me about yourself?
·         Start with your name.
·         Give your place information.
·         Education in short.
·         Job Experience.
·         Family details in short.
Example:
My Name is Muqthiyar Pasha, I Live in Riyadh, I have done B. Sc in Information Technology and MBA in Information Systems. I have 10 years’ experience in IT & I live with my Family in Riyadh.


    Why are you looking for a job?
·         Thanks explain what you learn from past job.
·         Share your reason for job change.
·         Relate to career goals.
Example:
I am thankful to my previous organization, because I have learnt a lot of things from there. According to me changes are necessary for everyone to enhance your skills. Knowledge & for personal growth. Your organization is a good platform where I can learn more.


3  What are your strengths?
·         Adaptation.
·         Hardworking.
·         Honest.
·         Flexible.
·         Optimistic.
·         Fast decision making.
·         Self-motivation.
Example:
I am honest, self-motivated & hardworking professional with positive attitude towards my career & live.


4 What are your weaknesses?
·         Straight forward.
·         Impatient.
·         Sensitive.
·         More talkative.
·         Trust people very quickly.
·         I can’t say no when someone ask for help.
·         Take decisions very quickly.
·         Get nervous when talk to strangers.
Example:
I can’t say no when someone ask for help & I’m a bit lazy in which I’m not interested.


      What are your salary requirements?
·         Never share your salary requirement as a fresher.
·         Experience candidate can share their expected salary.
·         Always say yes as per the company norms for job.
Example:
(Fresher) I am a fresher, salary is not first priority for me. This is a big platform to start my career & I also want to improve my knowledge & skills and gain experience so I expect a considerable of salary according to my ability & your company’s norms which I will fulfill my economical needs.
(Experienced)  My current package is (CTC Amount) and I expect (Some percentage) of increment.


6.  What are your career goals?
·         Short term goal.
·         Long term goal.
Example:
My short term is to get a job in required company where I can utilize my experience and skills & improve my career path.
My long term goal is to be in respectable position in that organization.


7.  Why should I hire you?
·         Share your knowledge.
·         Work experiences.
·         Skills related to job.
·         Career goals.
Example:
Sir, I have Theoretical knowledge and hands on experience on the related job and I can do hard work for my organization & I will put all my efforts to the good progress of my organization. Being punctual & sincere I can finish the work given to me on time & try to fulfill all the needs of the company from me.


8.  Why do you want to do work with our company?
·         Tell them what you like about the company.
·         Relate it to your long term career goals.
Example:
Sir. It’s a great privilege for anyone to work in a reputed company like yours. When I read about your company I found that y skills are matching your requirement where I can showcase my technical skills to contribute to the company growth.


9.  Finally, do you have any questions to ask for me?
·         Express thanks.
·         Salary structure.
·         Job timing.
·         Job Location.
·         Overtime allowances.
·         Timing period.
·         Transport facility.
Example:
Thank you giving me this opportunity. Sir, I would like to know the job timing & transport facility & what will be the job location & salary scale for this job in your organization.
at No comments:
Labels: , ,

Tuesday, March 13, 2018

End Dating Seeded Responsibilities

End dating seeded responsibilities that are not assigned to user, meaning no users are assigned to the responsibility

--Get List of responsibilities

SELECT fr.responsibility_id,
               fr.application_id,
               fr.data_group_application_id,
               fr.data_group_id,
               fr.menu_id,
               fr.web_host_name,
               fr.web_agent_name,
               fr.group_application_id,
               fr.request_group_id,
               fr.responsibility_key,
               frt.responsibility_name,
               frt.description,
               fr.start_date,
               fr.version
          FROM fnd_responsibility_tl frt, fnd_responsibility fr
         WHERE frt.responsibility_name in ('India Local Order Management')
               AND frt.language = 'US'
               AND fr.responsibility_id = frt.responsibility_id;
             
             
--Run Below API to end date responsibility

/* Responsibility End Date */
DECLARE
    CURSOR c1
    IS
        SELECT fr.responsibility_id,
               fr.application_id,
               fr.data_group_application_id,
               fr.data_group_id,
               fr.menu_id,
               fr.web_host_name,
               fr.web_agent_name,
               fr.group_application_id,
               fr.request_group_id,
               fr.responsibility_key,
               frt.responsibility_name,
               frt.description,
               fr.start_date,
               fr.version
          FROM fnd_responsibility_tl frt, fnd_responsibility fr
         WHERE     frt.responsibility_name IN
                       ('India Local Order Management')
               AND frt.language = 'US'
               AND fr.responsibility_id = frt.responsibility_id;
BEGIN
    FOR i IN c1
    LOOP
        BEGIN
            FND_RESPONSIBILITY_PKG.UPDATE_ROW (
                X_RESPONSIBILITY_ID           => i.responsibility_id,
                X_APPLICATION_ID              => i.application_id,
                X_WEB_HOST_NAME               => i.web_host_name,
                X_WEB_AGENT_NAME              => i.web_agent_name,
                X_DATA_GROUP_APPLICATION_ID   => i.data_group_application_id,
                X_DATA_GROUP_ID               => i.data_group_id,
                X_MENU_ID                     => i.menu_id,
                X_START_DATE                  => i.start_date,
                X_END_DATE                    => SYSDATE - 1,
                X_GROUP_APPLICATION_ID        => i.group_application_id,
                X_REQUEST_GROUP_ID            => i.request_group_id,
                X_VERSION                     => i.version,
                X_RESPONSIBILITY_KEY          => i.responsibility_key,
                X_RESPONSIBILITY_NAME         => i.responsibility_name,
                X_DESCRIPTION                 => i.description,
                X_LAST_UPDATE_DATE            => SYSDATE,
                X_LAST_UPDATED_BY             => -1,
                X_LAST_UPDATE_LOGIN           => 0);

            COMMIT;

            DBMS_OUTPUT.put_line (
                i.responsibility_name || ' has been updated !!!');
        EXCEPTION
            WHEN OTHERS
            THEN
                DBMS_OUTPUT.put_line ('Inner Exception: ' || SQLERRM);
        END;
    END LOOP;
EXCEPTION
    WHEN OTHERS
    THEN
        DBMS_OUTPUT.put_line ('Main Exception: ' || SQLERRM);
END;
/

Verify Below Documents and take decision based on usage of applications/modules in your Organization.
What Is The Impact Of Disabling Oracle Seeded Users? (Doc ID 418767.1)
Is it Safe To End Date Some Applications Users like GUEST (Doc ID 783428.1)
End Dating Seeded Responsibilities (Doc ID 390448.1)
at No comments:
Labels: , , ,
Subscribe to: Posts (Atom)

Some Tips About FNDLOAD

Data Synchronization  Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...