EBS 12.2 New Installation with RAC DB

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

EBS 12.2 New Installation with RAC DB

veysel
Hello,
I am trying to install EBS 12.2 with RAC Database. I have completed all pre-req, but I faced an error when installation of db tier.
I reviewed log files and I saw these steps;
Db restore completed successfully, but later I think system try to convert this database to RAC db. And it runs the RACAutoconfig. And here is the config logs error,
[main] [ 2023-12-14 20:38:32.440 EET ] [RuntimeExec.runCommand:229]  Connection paramaters values:
[main] [ 2023-12-14 20:38:32.440 EET ] [RuntimeExec.runCommand:229]       Database server hostname     ==>  XXXXXXXX.LOCAL
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]       Database listener port       ==>  1533
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]       Database SID                 ==>  null
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]       Database schema name         ==>  APPS
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]  
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]  Could not Connect to the Database : ORA-01034: ORACLE not available
[main] [ 2023-12-14 20:38:32.441 EET ] [RuntimeExec.runCommand:229]  ORA-27101: shared memory realm does not exist

It looks like script cannot read the SID name. I checked the TNS_ADMIN location and I found the strange naming.

null_myhostnane samples  shrept.lst  UEBSP_myhostname

Do you have any comment about this error? I cannot find anything on Oracle Support.

Note : I notice the reverse DNS not working in my server. I mean;
nslookup scan-hostname command gives an IP but
nslookup scan-ip command give error message. (it doesn't return result for All private and public IP's )

Thank you for your sharing and your supports.
BR

Reply | Threaded
Open this post in threaded view
|

Re: EBS 12.2 New Installation with RAC DB

veysel
Hi,
We start dbca manually and noticed RAC doesn't configure properly. There is a communication problem between RAC services and DB services. And we will install RAC again.

Thank you.
BR.
Reply | Threaded
Open this post in threaded view
|

Re: EBS 12.2 New Installation with RAC DB

ErmanArslansOracleBlog
Administrator
Installing RAC again? What do you mean by RAC? If it is just the GRID and ASM, then it is OK..
Please remember the following;
A fresh install cannot be done in a pre-created database, single node or RAC-enabled.
Such a thing is only applicable to do an Upgrade. Other than that, rapid install will create its database from scratch using the downloaded CD's.

So you started dbca manually, just to ensure that your environment is okay, able to run a RAC database without a problem, right? But even then, you got some communication problems between RAC services and DB services.. This is so generic. No data for me to comment on this.

Anyways, you have ORA-27101 and you have Database SID ==> null in the autoconfig log (I believe..)
If your DB was okay, up& running properly as a RAC database, then probably you had some config missing in DB or Cluster level. (a config which is needed by EBS for reading the SID of the database) -- this may be a consequence of another missing thing.

You may encounter the same issue after reinstalling GRID and retrying the rapid install.. If that's happens, please send me the whole autoconfig log, your listener services output, your srvctl output, your db name and sid. With all that, I could help you.

Also check the following note which is relevant with the context of your problem ->

Checks and Potential Issues Installing EBS R12.2 on RAC Cluster using Rapid Install (Doc ID 1595139.1)