Got it

Under the oracle user, using sqlplus "/as sysdba" to log in the data fails

Created: Jul 1, 2020 08:22:26Latest reply: Jul 1, 2020 08:27:56 506 3 0 0 0
  HiCoins as reward: 0 (problem unresolved)

Hello, everyone!

Have a nice day to you!

I have a question below:

Under the oracle user, using sqlplus "/as sysdba" to log in the data fails, resulting in the following error:

mdsp>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.7.0-Production on Friday February 15 15:04:39 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
please enter user name:
Produces an error:
ERROR:
ORA-01031: insufficient privileges

Can you help me? thanks!

Featured Answers

Recommended answer

yuexiaqiaomensheng
Created Jul 1, 2020 08:26:46

 

hello dear


1. Use sqlplus "/as sysdba" to log in as a super administrator to check whether the same problem exists
2. Please confirm whether the recent configuration has been changed, such as changing the read and write permissions of the /etc/passwd file from 644 to 640;
3. If the permissions are changed, after changing the read and write permissions of the passwd file back to 644, log in with sqlplus "/as sysdba" to check whether it is normal
4. Change the read and write permissions of the /etc/passwd file back to 644,
When using sqlplus "/as sysdba" to log in to the database as a super administrator, you need to read the /etc/passwd file.

View more
  • x
  • convention:

All Answers
Hello, user_3880819.
It's nice to meet you in the community.
We're working on your problem. Please be patient.
View more
  • x
  • convention:

 

hello dear


1. Use sqlplus "/as sysdba" to log in as a super administrator to check whether the same problem exists
2. Please confirm whether the recent configuration has been changed, such as changing the read and write permissions of the /etc/passwd file from 644 to 640;
3. If the permissions are changed, after changing the read and write permissions of the passwd file back to 644, log in with sqlplus "/as sysdba" to check whether it is normal
4. Change the read and write permissions of the /etc/passwd file back to 644,
When using sqlplus "/as sysdba" to log in to the database as a super administrator, you need to read the /etc/passwd file.

View more
  • x
  • convention:

Posted by yuexiaqiaomensheng at 2020-07-01 08:26  hello dear1. Use sqlplus "/as sysdba" to log in as a super administrator to check whether the same ...
Ok, thanks!
I will try it!
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.