1. After ODP. NET 10.2 is installed, its Net Manager and Net Configuration Assistant cannot be opened. After clicking the Start menu, there is no response.
My solution: uninstall ODP. NET 10.2 and reinstall ODP. NET. Pay attention to the following two points during installation: a) the installation directory should not contain null characters, such as Program Files. B) Select Oracle Data Provider for. NET 1.x 10.2.0.2.20 and Oracle Developer Tools for Visual Studio. NET 2003 10.2.0.2.20.
Cause: I don't know if Visual Studio 2003 is not installed, but the related components are selected.
2. ORA-12638 credential retrieval failed.
Scenario: Oracle 9i Server and Client are installed on the machine, and then ODP. NET 10.2 and 9i clients can be connected. The above error is reported when the 10g Client is connected for test.
Solution: Open NETWORK \ ADMIN \ sqlnet. ora under the installation directory of ODP. NET, comment out the line "SQLNET. AUTHENTICATION_SERVICES = (CNT)", or change it to "SQLNET. AUTHENTICATION_SERVICES = (NONE ).
Cause: credential retrieval failed because Oracle cannot apply OS authentication. Refer to about ora-12638 credential retrieval failed? How can this problem be solved ?.
3. Create a synonym in Oracle. When you use a synonym during storage, "the table or view does not exist" Grant Select On user_table To erp;
Grant Update On user_table To erp;
Grant Execute On user_procedure To erp;
Cause: When an anonymous block is executed, the object permission is obtained by logging on to the user's role, but the permission cannot be obtained by the role in the stored procedure. The system permission/object permission must be explicitly granted to the user.
4. ORA-12523: TNS: The Listener did not find a routine for client connection
Problem: Sqlplus "sys/sys @ erp as sysdba ";
Shutdown immediate;
Startup migrate;
Prompt when executing the startup statement
The ORACLE routine has been started.
ORA-12523: TNS: The Listener did not find a routine for client connection
Solution:
Ora92 \ network \ admin \ listener. ora, original content:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e: \ oracle \ ora92)
(PROGRAM = extproc)
)
)
Add a SID_DESC:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e: "oracle" ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = e: \ oracle \ ora92)
(SID_NAME = dev)
)
)
Dev is the oracle Instance name, restart oracle services, and create a net service named dev. You can use this net service to perform the preceding operations.
5. encountered this error when executing exp: EXP-00056: encountered ORACLE error 942
The patch of oracle 9i is not complete (the patch program may be installed, but catpatch. SQL is not executed) Shutdowm immediate;
Startup migrate;
@ "% Oracle_home % \ rdbms \ admin \ catpatch. SQL ";
Cause of estimation: The dmp file is exported from the upgraded oracle 9i server and imported to the test machine that has not been upgraded. In this way, the above error message is displayed when exporting data from the test machine.