Shulou(Shulou.com)06/01 Report--

The import user needs to be authorized as DBA.

Then use this user name for import. Note that the import user and the dmp export user need to be consistent.

If connect / as sysdba, the prompt ORA-01031: insufficient privileges appears

Step 1: check whether the system user belongs to ora_dba, and add it if you are not in the ora_dba group.

The second cloth: check whether the SQLNET.AUTHENTICATION_SERVICES setting in sqlnet.ora is NTS, if not, please modify it, and modify the result SQLNET.AUTHENTICATION_SERVICES= (NTS).

Step 3: check whether the environment variable path server/bin precedes client_1\ bin, and the query client_1\ bin precedes server/bin as follows:

D:\ oracle\ product\ 10.2.0\ client_1\ bin;d:\ oracle\ product\ 10.2.0\ db_1\ bin;%SystemRoot%\ system32;%SystemRoot%;%SystemRoot%\ System32\ Wbem;%SYSTEMROOT%\ System32\ WindowsPowerShell\ v1.0\;% JAVA_HOME%\ bin

After modification

D:\ oracle\ product\ 10.2.0\ db_1\ bin;d:\ oracle\ product\ 10.2.0\ client_1\ bin;%SystemRoot%\ system32;%SystemRoot%;%SystemRoot%\ System32\ Wbem;%SYSTEMROOT%\ System32\ WindowsPowerShell\ v1.0\;% JAVA_HOME%\ bin

Step 4: reopen the command window (required) and log in again.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.