No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48675 | Total active users | 1328 | Act. users last 24h | 0 | Act. users last hour | 0 | Registered user hits last week | 24 | Registered user hits last month | 452 |
|
Go up
oracle 19c installation problem
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 ...... |
     |
Michel Cadot |
May 13, 2022, 09:57 |
Any feedback?
... |
|
Michel Cadot |
May 20, 2022, 17:58 |
Subject: |
oracle 19c installation problem |
Author: |
madhu g, India |
Date: |
May 13, 2022, 07:34, 51 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, 51 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, 51 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, 51 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, 51 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, 51 days ago |
Score: |
       |
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, 43 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
|