ORACLE DBA: October 2019

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>

====

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:

FRM-92101: A failure has occurred on the Server. You will need to reestablish your session

Oracle forms opening slowly troubleshooting

oacore not starting up troubleshooting tips

Some more useful and helpful links:

Real Time Oracle Apps DBA Interview Questions

ORA-01110 data file 1: system01.dbf recovery

R12.2 ADOP Patching Phases Finalize and Cutover

Why We are not Rich

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 1^st floor and another person came and asked owner for another half space on 1^st 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:

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

ORA-01110 data file 1: system01.dbf recovery

R12.2 ADOP Patching Phases Finalize and Cutover

TKPROF Concepts with Syntax and Real time example

R12.2 Adop Phases in Oracle EBS

Regards,

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

Dear DBA-mates, Hope you all are doing great!!!

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

Recently, while starting the weblogic services we found this below error. This is very common error for any weblogic DBAs. And almost people may know the solution.

But if a DBA working in PROD, at least once he will check either in google or colleagues to kill the process in PROD.

So, we thought lets share this error with you all for future references without any doubts.

weblogic java error:

$tail -f nohup.out

Solution:

$ps ucx

Here, it will show all the running process.

Check for the JAVA process and kill it.

$kill -9 <java process>

Again start the services, it will work.

Work around -2:

If still not working then you need to check the .lok file and remove that and then again start the services.

First either bring down the weblogic services or kill the process including java process and then remove the .lok file.

Expected Path:

../Middleware/user_projects/domains/<your domain name>/servers/<mostly AdminServer>/tmp

You can find out .lok file. You either rename it or remove it.

From AdminServer directory, you can use below commands to find out the *.lok files also:

$find . –name *.lok –exec ls –ltr {} \;

Note: Always be careful and 100 % sure while removing any files.

Some more useful links:

ORA-01110 datafile 1: system01.dbf recovery

R12.2 ADOP Patching Phases Finalize and Cutover

Concurrent Manager Performance Tuning Tips in Oracle EBS R12

TKPROF Concepts with Syntax and Real time example

Why We are notRich

Regards,

Pages

Sunday, 20 October 2019

Thursday, 10 October 2019