For Oracle database in remote multi instance linux environment, an error is reported when executing conn/as SYSDBA: ora-01031: insufficient privileges. The solution process is as follows:
Step 1: find the sqlnet.ora file. Add the following two
SQLNET.AUTHENTICATION_SERVICES=(ALL)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)
Step 2: after saving, exit and execute lsnrctl reload
Step 3: the following errors occur after I finish executing:
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted```
To solve this problem, execute: Chmod 777/var/TMP/.Oracle
Step 4: specify the connection instance. The orcl here should fill in your own instance name.
export ORACLE_SID=orcl
Step 5: when reconnecting, an error is reported connected to an idle instance.
. Note that this only means that the instance is not started, which is not a big problem. First query the status select status from V $instance
Step 6: start
startup
Since then.
Read More:
- How to Solve Oracle startup monitoring error
- Linux: How to Solve vim ~/.bashrc Execute Error
- Linux: How to Solve sudo operate Error
- How to Solve Roscore Run error [Install ROS]
- Linux: How to Solve Rabbitmq Plug-in Install Error
- How to Solve Error: Driver “kvm2“ not found
- How to Solve Error: “Hdaudio hdaudioc0d2: unable to bind codec”
- How to Solve gtid master-slave replication connecting Issue
- How to Solve A-LOAM Ceres Version Error
- How to Solve labelme Install Error in Ubuntu
- Linux: How to Solve pyperclip Module Error
- Ffmpeg: How to Solve error initializing filter ‘gltransition’
- How to Solve Ubuntu “Failed to fetch” Error
- How to Solve Linux Error: -bash: unzip: command not found
- How to Solve NPM Error: listen EADDRINUSE 127.0.0.1:8080
- How to Solve Xmind Install Error in Ubuntu System
- How to Solve Git Filename too long Error
- How to Solve Mujoco Install Error in Ubuntu (Pycharm Run Error)
- How to Solve No approve protocol error when running kettle on Linux
- How to Solve C++ Error: “no matching function for call to ‘atoi/atof’”