No question at this time
DBA Top 10
1 M. Cadot 10300
2 A. Kavsek 7200
3 B. Vroman 4200
4 P. Wisse 3500
5 J. Schnackenberg 3200
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48548
Total active users1403
Act. users last 24h3
Act. users last hour1
Registered user hits last week214
Registered user hits last month641
Go up

Dbca hangs at 59%
Next thread: oracle data guard windows
Prev thread: Peformance got Degreded after cross platform migration from aix to linux 12c

Message Score Author Date
Im creating database in oracle 12.2.0.1 on windows...... Benny Wilson Oct 07, 2020, 09:37
Hi Benny Wilson, The Oracle user needs to be in...... Philip Wisse Oct 07, 2020, 09:50
Hi, Were using a domain/user and its added in ...... Benny Wilson Oct 07, 2020, 10:23
Hi Ben, It's just another notation for the same...... Philip Wisse Oct 07, 2020, 10:28
How is it that's it's working now? After changi...... Benny Wilson Oct 07, 2020, 10:31
Hi Benny, it's partially true what Philip said,...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Ales Kavsek Oct 07, 2020, 14:29

Follow up by mail Click here


Subject: Dbca hangs at 59%
Author: Benny Wilson, India
Date: Oct 07, 2020, 09:37, 19 days ago
Os info: Windows 2012 r2
Oracle info: Oracle 12.2.0.1
Error info: Ora 28547 probable net admin error
Message: Im creating database in oracle 12.2.0.1 on windows 2012 r2 64 bit and Dbca hangs at 59% of completion in db clone step. I've checked the dbca logs and it's stuck in datapatch.bat step.

When I googled this, I get that I'm supposed to change the sqlnet.ora file from none to NTS, but the dbca creation fails at 2% progess with ora 28547 netadmin error.

Datapatch log during installation is as below


SQL Patching tool version 12.2.0.1.0 Production on Mon Oct 5 14:26:16 2020 Copyright (c) 20122017 Oracle. All rights reserved.

Build label: RDBMS 12.2.0.1.8 WINDOWS, X 641702104

Log file for this invocation: D:\oracle 12c\app\oradba\cfgtoollogs\sqlpatch\sqlpatch 7776_2020_10_05_14_26_17\sqlpatch invocation. log

SQL Patching arguments:

verbose:

force: B

prereg:

upgrade mode only:

oh:

bundle series:

Ignorable errors:

bootstrap:

skip upgrade check: 1

userid:

pdbs:

noq1:

app:

binary config:

Connecting to database...

Connection using 0/S authentication failed

Enter user id that can connect as SYSDBA: Enter password for : Database connect failed with: GetConsoleMode failed, LastError-161 at D:/oracle 12c/app/oradba/product/dbhone 1/per 1/site/1ib/Term/Readkey.pm line 334.

Please refer to MOS Note 1609718.1 and/or the Invocation log D: \oracle12c\app\oradba\cfgtoollogs\sqlpatch\sqlpatch 7776_2820_10 05_14 26 17\sqlpatch invocation.log for information on how to resolve the above errors.

SQL Patching tool complete on Wed Oct 7 11:56:36 2020
Any solutions or workaround would be helpful.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Dbca hangs at 59%
Author: Philip Wisse, Netherlands
Date: Oct 07, 2020, 09:50, 19 days ago
Message: Hi Benny Wilson,

The Oracle user needs to be in the ORA_DBA group.
You can test connection with: sqlplus / as sysdba

Remove all files and restart DBCA

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Dbca hangs at 59%
Author: Benny Wilson, India
Date: Oct 07, 2020, 10:23, 19 days ago
Message: Hi,

Were using a domain/user and its added in ora_dba group, but not able to run sqlplus / as sysdba.

So created a service using oradim with pfile.

Still not able to log in.

Checked the services.msc tab, clicked on db service. I tried to change the log in by giving the same domain/user, but now it's showing as username@domain.com.

Ex- domain user RNCS/Ben now it's reflecting as ben@rncs.com

I'm now able to login to sqlplus.

Is domain\username and username@domain.com different? Or is there any problem with this username or ad?


And able to login in sqlplus.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Dbca hangs at 59%
Author: Philip Wisse, Netherlands
Date: Oct 07, 2020, 10:28, 19 days ago
Message: Hi Ben,

It's just another notation for the same.
Default would be user@domain.local

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Dbca hangs at 59%
Author: Benny Wilson, India
Date: Oct 07, 2020, 10:31, 19 days ago
Message: How is it that's it's working now?

After changing the logon in the services tab
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Dbca hangs at 59%
Author: Ales Kavsek, Slovenia
Date: Oct 07, 2020, 14:29, 19 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message: Hi Benny,

it's partially true what Philip said, DOMAIN\username is old notation and UPN (username@domain.com) is new (preffered) notation. But behind a scene there is a difference how credential is searched, if AD/DNS is working perfectly, then you won't see a difference, if there is something wrong in AD/DNS infrastructure then you might experience different results, depending on which annotation you're using.
It's often frustratingly difficult to troubleshoot AD related defects, because some admin somewhere fixes something (on purpose or more often by accident), not telling anyone, and suddenly everything works fine.

If you're interested I found a good thread on serverfault:

https://serverfault.com/questions/371150/any-difference-between-domain-username-and-usernamedomain-local

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here