No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Go up

oracle 19c installation problem
Next thread: ORA-01653: unable to extend table table_name by 8192 in tablespace tablespace _name
Prev thread: Application slowness performance issue

Message Score Author Date
Hi, I am trying to install oracle 19c using th...... madhu g May 13, 2022, 07:34
What is the content of "E:\ORACLE\cfgtoollogs\db...... Michel Cadot May 13, 2022, 07:55
You said "I cannot connect to oracle from sql*pl...... Michel Cadot May 13, 2022, 08:01
the content of dbmssml.sql is as follows... C...... madhu g May 13, 2022, 09:29
HI, I used sqlplus from command interface a...... madhu g May 13, 2022, 09:33
This error means the Oracle instance service is ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot May 13, 2022, 09:57
Any feedback? ... Michel Cadot May 20, 2022, 17:58

Follow up by mail Click here


Subject: oracle 19c installation problem
Author: madhu g, India
Date: May 13, 2022, 07:34, 140 days ago
Os info: windows 10 64 bit
Oracle info: oracle 19c
Error info: [INS-20802] database configuration assistant failed

look at the log file "e:\oracle\cfgtoollogs\orcl\orcl.log" for further details

-----------------------------------------------
The orcl log file contents is as follows:

[ 2022-05-11 19:08:00.705 IST ] [WARNING] [DBT-09251] The listener configuration is not selected for the database. EM DB Express URL will not be accessible.
[ 2022-05-11 19:08:02.608 IST ] Prepare for db operation
DBCA_PROGRESS : 8%
[ 2022-05-11 19:08:04.031 IST ] Copying database files
DBCA_PROGRESS : 31%
[ 2022-05-11 19:17:16.278 IST ] Creating and starting Oracle instance
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 46%
DBCA_PROGRESS : 100%
[ 2022-05-11 19:34:17.538 IST ] [FATAL] Error while executing "E:\WINDOWS.X64_193000_db_home\rdbms\admin\dbmssml.sql". Refer to "E:\ORACLE\cfgtoollogs\dbca\orcl\dbmssml0.log" for more details. Error in Process: E:\WINDOWS.X64_193000_db_home\perl\bin\perl.exe
DBCA_PROGRESS : 31%
DBCA_PROGRESS : 8%
DBCA_PROGRESS : 0%
Message: Hi,

I am trying to install oracle 19c using
the software downloaded from oracle website.
At 7th step ,dbca (database configuration assistant) fails.I un-installed and tried to install again
but it throws the same error. If I skip the step,
the installation completes but I cannot connect
to oracle from sql*plus or sql developer tool.
I am attaching the error pic and log files.
plz help to resolve the issue.

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle 19c installation problem
Author: Michel Cadot, France
Date: May 13, 2022, 07:55, 140 days ago
Message:
What is the content of "E:\ORACLE\cfgtoollogs\dbca\orcl\dbmssml0.log"?

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

Subject: Re: oracle 19c installation problem
Author: Michel Cadot, France
Date: May 13, 2022, 08:01, 140 days ago
Message:
You said "I cannot connect to oracle from sql*plus", what command did you try? What error did you get?

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

Subject: Re: oracle 19c installation problem
Author: madhu g, India
Date: May 13, 2022, 09:29, 140 days ago
Message:
the content of dbmssml.sql is as follows...

CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS 'E:\WINDOWS.X64_193000_db_home\bin\oraqsmashr.dll';
/

dbmssml0.log file is 0 kb and nothing is there.

thanks and regards

madhu





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

Subject: Re: oracle 19c installation problem
Author: madhu g, India
Date: May 13, 2022, 09:33, 140 days ago
Message:
HI,

I used sqlplus from command interface
and tried

user name :sys as sysdba
password : --- the same password at the time of installation...

It shows the error the following error:

ora-12560: protocal adaptor error

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

Subject: Re: oracle 19c installation problem
Author: Michel Cadot, France
Date: May 13, 2022, 09:57, 140 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
This error means the Oracle instance service is not started.
1/ Have you correctly set ORACLE_SID?
2/ Try to manually start the service OracleService<SID>.

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

Subject: Re: oracle 19c installation problem
Author: Michel Cadot, France
Date: May 20, 2022, 17:58, 132 days ago
Message:
Any feedback?

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