Ladies and gentlemen, please help younger brother, I installed Oracle, login can not sqlplus prompt error is: ora-01017: invalid username/password; logon denied. the username and password of the database I created are slzyy. It is strange that I can log on to sqlplus using the CMD command, and PLSQL can also log on normally. How can I solve this problem. thank you.
Question added:
I cannot test this database in net manager. The prompt is as follows: I am trying to connect with the following user ID: slzyy test failed. ORA-01017: invalid username/password; logon denied may have errors in the entered field, or the server connection is not ready
Best Answer
After creating a user to grant permissions, complete User Creation steps: 1. sys User Logon 2. Create user slzyy identified by slzyy; 3. grant permissions to resource, connect to slzyy; Note: you can log on after the above steps. *****************
Best Answer
1. Open CMD and enter netca. 2. Select Local net service name configuration → next. 3. Select Add> next. 4. enter the name of the Oracle service on the server you want to connect to in [service name] → next step. 5. select TCP> next. 6. Enter the IP address of the server you want to connect to in host name. The port number remains unchanged → next step. 7. Select "test"> "Next. (You can also choose not to test) ※1 if the test fails, click Change logon and enter a user name and password that will certainly be logged on. → OK, [connecting... the test is successful.] The test is successful. ※2 if the test fails, click [previous] to confirm the [service name] and [host name] you wrote, make sure that the Oracle listening service on the server you want to connect to is enabled. 8. Enter the local service name you want to use in [net service name] → next step. ※Sqlplus user/passwd @ local service name ]. 9. Select "no"> "Next. 10. The word "net service configuration completed" appears → next step. 11. Click Finish to complete the service configuration. 12. After the above service configuration is complete, enter the following command in cmd to remotely log on to the Oracle server: sqlplus user_name/password @ the local service name must be remembered, the local service name above is the service name you wrote in step 1. -- The above is helpful to you.