Skip to Main Content
Forums

Oracle Database Express Edition (XE)

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!

ORA-12560: TNS:protocol adapter error after successful installation of 18 xe

SullivanKMar 16 2019 — edited Mar 19 2019

Hi,

I installed 18 XE on windows 10, but get this error when I try to login via cmd. I installed it via the installation wizard and left every setting on default. Already tried restarting, uninstalling and reinstalling.

After reading Receive ORA-12560 TNS:protocol adapter error with XE 18c / Windows I tried changing my windows environment settings but did not find any for Oracle, which is weird right?

Also, with Oracle 11xe i was used to having 4 windows services and now I only see two: a recovery service and listener. Is that normal?

thanks,

Sullivan
This post has been answered by SullivanK on Mar 18 2019
Jump to Answer

Comments

Billy Verreynne

SQLCL is a client application. It does not have users and passwords to use.
SQLCL connects to database servers (db instances). The database typically requires a username and password for authentication. SQLCL may prompt for these credentials to supply to the database.
There are no default usernames and passwords to use in today's Oracle database. Most schemas are also locked by default when the database is created.
Ask your DBA for the details of the database and user schema to use.

User_21BG6

i have installed sqlcl-21.3.3.322.1724..but it is asked user name and password in command prompt..please give the solution

Mike Kutz

What database are you trying to connect to?

User_H3J7U

Use /nolog parameter.

thatJeffSmith-Oracle

If you don't know your username and/or password, you need to talk to the person responsible for your database. If you don't know who that is, we can't help you.

1 - 5

Post Details

Added on Mar 16 2019
12 comments
6,947 views