Tuesday 26 November 2019

How to create weblogic user

Dear DBA-mates, Hope you all are doing well!!!
How to create Weblogic user is a Weblogic administrative task. 

We are not sure if an Oracle Apps DBA also do it because we have never been done it as Oracle Apps DBA.

But it is important and easy task which we should know it. It may help in either in interview or work environment.

So, let’s start the steps for creating user in Weblogic:

1. Login to weblogic console url with Weblogic user and password.

2. Then click on "Security Realms" under Domain Structure, just below Services.

3. Then click on "myrealm".

4. After that click on "Users and Groups" tab (i.e 2nd tab). Then select "User" tab (just below 1st tab).

5. Then click on "New".

6. Then we will see "Create New user" form where you have to fill-up below details:

1. Name: Required Field
2. Description:
3. Provider:
4. Password: Required Field
5. Confirm Password: Required Field

Note: Name, password and Confirm password are Mandatory/Required fields which we need to provide value.

7. Now click on "Ok".

Please find the below path in shot-cut which may more helpful:

Home > Summary of Security Realms > myrealm > Users and Groups >New > Create New User

Also you can create here user, groups, members etc…

Note:

We have a complain about you guys that you people don’t answer the question’s here… hahahah, hmmm everyone wants ready meals: P

Hope these steps are clear and helpful. Please let us know for any concerns either to send email or in our comment box.

Some more useful links: 








Regards,

Sunday 24 November 2019

Realtime Oracle Apps DBA Interview Questions and Answers

Dear DBA-Mates, Latest Apps DBA Interview Questions and Answers.
Hope you all are doing Good!!! We have some topics but due to busy scheduled not able to present here.

But back with some New Questions and Answers which may useful here, also I found as these are simple and good questions.

Questions:
Q 1. Please describe about your job and task activity?

Note: As we all know this is very common question and answer… It depends on person to person…

Q 2. How to do troubleshoot oacore?

Q 3. Where is location path of oacore log file?

Q 4. How to find out which user is pointing to which oacore in case we have 5 oacore?

Note: Please answer this questions if anyone aware about it.

Q 5. What is http server and how it works?

Q 6. What is http.conf file and ohs.conf file and where is the location?

Q 7. What is EBS Login flow?

Q 8. How to troubleshoot Long running program if there is no lock, no server load and everything is normal?

Q 9. What is EBS version?

Q 10. What will happened if you run Prepare phase?

Q 11. What is location of Patch log?

Q 12. If we have created custom top, how adop will sync to patch file system?

Q 13. How the prepare phase knows to sync Custom_top to patch file system?

Q 14. If we have applied small patches then do we need to run fs_clone phase?

Q 15. If cutover failed due to some reason, how to troubleshooting?

Q 16. If u ran prepare phase, 20 programs are running, and during cutover phase once completed what will be the status of those programs?

Q 17. How to create Weblogic user?

Q 18. Have you worked on any other technique other than EBS/DB?

Q 19. Have you done patching in Endeca?

Q 20. How ebs patch sync with Endeca?

Q 21. What is the version of RAC?

Q 22. What is flaks in 12c RAC , new feature in RAC?

Q 23. How you worked on RMAN?

Q 24. What is backup strategy?

Q 25. How to find out database wait events?

Note: Answer will be publish very soon.

Some more useful and helpful links:
Regards,

Saturday 2 November 2019

How to change sysadmin password FNDCPASS in R12.1.3

Dear DBA-Mates, Hope you all are doing Great Job!!!
We know this is very simple and easy to change the sysadmin password in R12.1.3 but some people will may have confusion in it.

Because whenever I asked to change sysadmin password for my junior team they will hesitate and afraid. So thought to lets share which may useful here all.

Confusion:
 
Question: Do we need to run Autoconfig?
Answer: No.

Question: Do we need to bounce the Application Services?
Answer: No.

Note:
 
If found any issue then only need to restart the Apache, Forms, Reports, 8.0.6 listener and concurrent manager services.

Question: Do we need to change any others user’s password for this?
Answer: No.

Simply, we can change the password from FNDCPASS utility as shown below:

1. Run the env file.
$ . ./ora-data.blogspot.env

2. Cross check for correct server/host.

$ echo $TWO_TASK
ORA-DATA

$ FNDCPASS apps/<apps_password> 0 Y system/<system_password>  USER SYSADMIN <new_sysadmin_password>

Log filename : L1234567.log


Report filename : O1234567.out
bash-3.2$ cat L1234567.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 19-OCT-2019 06:52:00

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** USER SYSADMIN *****
+----------------------------------------------------------------------------+
Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 19-OCT-2019 06:52:01

+---------------------------------------------------------------------------+

$ exit

exit

You have new mail in /var/spool/mail/ora-data
$ exit
logout

How to set password in pbrun command in linux:

$pbrun ohsdba password-manager <Database_name> -set sysadmin

What is the current 'sysadmin' password?:<current_sysadmin_password>
Once more:<current_sysadmin_password>

$

Some more useful links:

What is PDB and CDB in oracle 12c

[Fixed] Weblogic Error: BEA-141281 unable to get file lock, will retry ...

Regards,