I said at first the steps to create a new user

1. First of all, I use the Scott user login oracle as sysdba.

Conn Scott/tiger as sysdba

2. Then I create a user

The create user Nick identified by Nick;

3. Modify the user's password.

The alter user Nick identified by nick123;

4. Create a table space.

The create in tablespace nick_nick datafile 'd: \ nick_nick. DBF' size of 500 m;

5. Create table space, also need to assign a table space users.

The alter user Nick default in tablespace nick_nick;

6. To the user permissions

Grant create session, create table, create a view, the create sequence, unlimited in tablespace to Nick.



To finish all the steps above can be a successful login after PLSQL, below


Then I use navicat login, below is the configuration screenshot


Click on the login prompt information below



Consulted a lot of online articles, and set up a pile of permissions, modify the password several times to no avail, don't know where the problem is. Although suggest there is something wrong with the account password, but I'm one hundred percent sure password is not wrong. Who have encountered similar problems, please answer

CodePudding user response:

Useless oracle for a long time, recently installed a local database, write some demo oracle problem is really unexpected,
Not enough is not the authority is the authority, clearly account password is true errors, somehow prompt accurate point I may know what the problem. The most annoying is some third-party tools is generally going to do some compatibility to connect oracle properly.
Mysql use habits, is really comfortable, not those ghosts.

Finally, I said to the above problems, the same local environment, another account created by default when installation socott can normal login.

CodePudding user response:

Can install a PLSQL, you use the tools I've never used

CodePudding user response:

Tnsping former, make sure this configuration is correct,
You have landed up sqlplus, useless service configuration, using navicat to read local service name

CodePudding user response:

Needed to be set before use up sqlplus oracle environment variables, in the current window temporarily set the set is=corp permanent set to baidu

CodePudding user response:

May be the unit running multiple instances of up sqlplus on even not wouldn;

Straight up sqlplus "Nick/nick123 @ wouldn" give it a try

CodePudding user response:

LSNRCTL status look at the listening state