After the Oracle database is created and odac is installed, Oracle may be inaccessible.

Steps for creating an Oracle database using tools ():

Step 1:

Part 2:

Part III:

Part 4:

Step 5:

Step 6:

Step 7:

Step 8:

Step 2:

Step 10:

Step 2:

Step 2:

Step 2:

Step 2:

Click "OK" to create a database.

Oracle odac

Running sqlplus sys/system as sysdba after installation may cause an error ORA-12154: TNS: Unable to parse the specified connection identifier.

Solution:

Install tnsnames in path D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin for Oracle. ora file content and tnsnames in E: \ app \ Administrator \ product \ 11.2.0 \ client_1 \ Network \ ADMIN (the Oracle odac installation path. the ora content is consistent.

For the currently installed database, we only needCodeCopy to E: \ app \ Administrator \ product \ 11.2.0 \ client_1 \ Network \ ADMIN:

Tnsnames

 1 Demo =  2 (Description =  3 (Address = (Protocol = TCP) (host =  **** ) (Port =   1521  ))  4 (CONNECT_DATA =  5 (Server =  Dedicated)  6 (SERVICE_NAME =  Demo)  7   )  8 )