Thanks for the question, Buridi.
Asked: September 01, 2023 - 3:10 pm UTC
Last updated: September 04, 2023 - 1:32 am UTC
Version: 18c
Viewed 1000+ times
You Asked
SQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 1 20:34:56 2023
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter user-name: SYSTEM/sys
ERROR:
ORA-12560: TNS: protocol adapter error
Enter user-name:
I Started Oracle Service no Use.
Can anyone help me? To find solution.
and Connor said...
Perhaps try command line. First lets cleanup the existing database you have
dbca -silent -deleteDatabase -sourceDB MYDBNAME -sysDBAUserName sys -sysDBAPassword MYSYSPASSWORD
and then create a fresh one
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname MYDBNAME -sid MYDBNAME -responseFile NO_VALUE -characterSet AL32UTF8 -sysPassword MYSYSPASSWORD -systemPassword MYSYSPASSWORD -createAsContainerDatabase false -numberOfPDBs 0 -databaseType MULTIPURPOSE -automaticMemoryManagement false -storageType FS -datafileDestination C:\oracle\oradata\ -ignorePreReqs -totalMemory 1536 -emConfiguration NONE
but the obvious question here is .... why 18c? Why not 19c?
We're not taking comments currently, so please try again later if you want to add a comment.