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,

Sunday, 20 October 2019

FRM-92060: Failed to connect to the Server. Bad machine specification:

Hi DBA-mates,Hope you all are doing well!!!
FRM-92060: Failed to connect to the Server. Bad machine specification: hostname.domain.com:port

We are back again with one of very important forms error FRM-92060: Failed to connect to the Server which may help you guys here...
We used to face this issue whenever we run the Autoconfig on applications node.

The issue is when we run Autoconfig on Application node and start the services the forms will open with error as "FRM-92060: Failed to connect to the Server. Bad machine specification: hostname.domain.com:port..."

But later on we found that because of running autoconfig on Apps nodes the previous/custom configurations files got updated and made some changes, so the forms won't open.

So, below is the one of the work around or solution which may help us here in future for quick references. 

Error:
FRM-92060: Failed to connect to the Server. 
Bad machine specification: hostname.domain.com:port

Details...
Java Exception:
java.net.UnknownHostException: hostname.domain.com
at java.net.AbstractPlainSocketlmpl.connect(Unknown Source)
at oracle.forms.net.SocketConnection.connect(Unknown Source)
at oracle.forms.engine.Runform.initConnection(Unknown Source)
at oracle.forms.engine.Runform.startRunform(Unknown Source)
at oracle.forms.engine.Main.createRunform(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)



Form solution:
=========

$su – applmgr 
Password:****

$cd $ORA_CONFIG_HOME/10.1.2/forms/server

$ls –ltr appsweb.cfg

Changed from
=========
serverPort=1234

serverName=<hostname as per unix>

domainName=<domain name>

To
====
serverPort=1234

serverName=<hostname as per ebs url>

domainName=<domain name>

Friends, this is one of the work around which worked for us.
In above example, almost time we saw that the “serverName” got changed to hostname which shows in UNIX but if we change it as per our ebs url, the forms open fine and worked correctly.

There is one more option if still not working above work-around, you can bounce the apache and oacore which may help in it.

Also, we have shared other issue and solutions related to forms which may help you.

Please go through that like:

Oracle forms opening slowly troubleshooting

oacore not starting up troubleshooting tips


Some more useful and helpful links:

Real Time Oracle Apps DBA Interview Questions

Regards,
Ora-data Team

Thursday, 10 October 2019

What is PDB and CDB in oracle 12c

Hi DBA-Mates, Hope you all are doing well.
What is PDB and CDB in oracle 12c

Day before yesterday, I give a presentation for my team about 12c features about what is PDB (Pluggable database) and CDB (Container Database).

And the good thing is, I got a good feedback also. So, I thought to share here with you all, it may helpful and tried to explain simple way.

Suppose, we are installing a database 12c, it will contain "Oracle metadata" and after that we put "User data and metadata"

Oracle Metadata (ex. sys and system schema) -- called CDB (Container Database)

User data/metadata -- called PDB (Pluggable database)

Old 11g:

Suppose, we have 2 clients then we have to create/install 2 database on the same server for their access where needed 2 instances, 2 cpus and other background process which makes more loads.

Now 12c Features:

In cloud or SaaS or pluggable Database:

Suppose, we have 1 server and we installed Fresh Database (DB with only Oracle Metadata e.x: like sys and system with objects).

So it will be act like CDB (Container database) or called as CDB (Container DB).

So, there will only one instance and their background process.

Then, there will space provided to users/clients to create their own schema/database.

So, if a client came and asked for database on server, then oracle provider can tell them CDB name, under which they can create their own schema/database.

Same if another user/client came, they can create their own in same server under same CDB.

So, there is no need to install again and again Oracle Metadata/ fresh database, no need to create many instances.

So, also it will be called as SaaS (Software as a Service).

And the User’s metadata or schema’s called as PDB (Pluggable Database)

Note: Of course, for this good hardware and servers required which is available now a days easily, no doubt.

Example in easy language which I have understood it:

Suppose, there is a building with 4 floors, only with hall on every floor. And there are facilities like lift, watchman, water-tanks, garden, bank ATMs.
One person came and he asked the owner that he want only half space in 1st floor and another person came and asked owner for another half space on 1st floor.

Owner provided them half-half space. And they (Customers) build the houses as per their requirements.

So, here facilities like lift, watchman, water-tanks, garden, bank ATMs both customers are using same but they have diff-diff ownership's.

Same-way, here land-plot and Facilities are like CDB and customer’s houses are PDB.

Hope this may useful. Thank you all!!!

Some more useful links:

ORA-01110 data file 1: system01.dbf recovery




Regards,