Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

GRID - Windows - Created Disks - Trying to create ASM 12c instance

ImraneASep 27 2024

Hi there

Trying to do : install GRID infrastructure on a test bed on windows server.

Issue : fails to create ASM instance using asmca

Get error : Configuring ASM failed: Configuring HA resource failed: ORA-28547 : connection to server failed, probable Net admin error.

Log file -→ E:\app\oraservice\cfgtoollogs\asmca

[Thread-43] [ 2024-09-24 18:58:37.278 BST ] [UsmcaLogger.logException:186] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:relieveASMFromSPFile
[Thread-43] [ 2024-09-24 18:58:37.278 BST ] [UsmcaLogger.logException:187] ORA-28547: connection to server failed, probable Oracle Net admin error

[Thread-43] [ 2024-09-24 18:58:37.278 BST ] [UsmcaLogger.logException:188] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28547: connection to server failed, probable Oracle Net admin error

Creates service, then does rollback.

Logged on as a test user with admin rights to test server.

Background:

Env :

Created two RAW Disks (DATA (300G) ; FRA (200G))

Oracle 12c (Oracle 12c 12.2.0.1.0) installed on windows (2019 Datacenter)(fully patched).

Run Installer for grid and failed on ASMCA step only. Otherwise successful install.

E:
SET ORA_CRS_BASE=E:\app\oraservice
SET ORA_CRS_HOME=E:\Software\grid
SET TNS_ADMIN=E:\Software\grid\network\admin
SET ORACLE_SID=+ASM
cd E:\Software\grid

Checks:

E:\Software\grid\bin>crsctl status res -t (all resources online)

E:\Software\grid\bin>lsnrctl status

E:\Software\grid\network\admin\not changed network config files.

Two services created, local system. Running and automatic.

Completed this task in Linux env, never had any issues. First time, trying this in windows.

Comments
Post Details
Added on Sep 27 2024
1 comment
52 views