The create connection error, url: JDBC: oracle: thin: @ localhost: 1521: former, errorCode 1017, the state 72000




Up SQLPLUS can login, but can't connect program to connect, prompting the user

CodePudding user response:

Local adoption is operating system certification, and the program USES a user password authentication, please check your listening is already open, whether related services has been launched,

CodePudding user response:

Services are normal

CodePudding user response:

I'm not saying the service, said the external connection service, also is to use LSNRCTL status check whether related services

CodePudding user response:

And connection string. See your tnsnames ora is how to write, localhost is used to define the IP address, if not, please change the IP connection string, or the localhost is can't be resolved,

CodePudding user response:

I don't know, but suggested that can look at the figure of an error also posted ~ QAQ

CodePudding user response:

Are you sure you connect the PDB, rather than the last, if CDB, program to connect is useless

CodePudding user response:

12 c, up sqlplus default connected directly to the last

CodePudding user response:

The building Lord solve have no? I also report the same error

CodePudding user response:

The original poster is the same solve not my fault

CodePudding user response:

I also encountered the same problem, can you tell me who can answer it!

CodePudding user response:

With, the building Lord solved?

CodePudding user response:

Oracle connection mode change a try of the program

CodePudding user response:

Measured in law in 1 minute!!!!!!!!!!!!!!!!!!!!!!!!!! When a database is created and login code is not corresponding to use the alter user & lt; The user name & gt; Identified by & lt; The new password & gt;; To modify the good, you first use up sqlplus/as sysdba login is modified,

CodePudding user response:

SID is sid_name not the service_name database

CodePudding user response:

The building Lord, solved? I also encountered the same problem, small white one, the answer, genuflect is begged

CodePudding user response:

Question 1
12 c is not compatible with low version PLSQL
In the sqlnet. Ora file new sqlnet. ALLOWED_LOGON_VERSION_SERVER=9
SQLNET. ALLOWED_LOGON_VERSION_CLIENT=9
Question 2
ORA - 01017: invalid username/password. Logon denied
In the sqlnet. Ora file adds sqlnet. ALLOWED_LOGON_VERSION_SERVER=n
SQLNET. ALLOWED_LOGON_VERSION_CLIENT=n
After password although support n above version, but at this time due to the password rules written in advance, lead to low version of the client can't identify,
At this time only need to alter user_name identified by passwd; Can be modified again,

CodePudding user response:

Your users to use the database administrator (dba permissions) login to perform "the alter user username identified by password;"

CodePudding user response:

The alter profile default limit password_life_time unlimited;