How to configure the Oracle client and the system super administrator cannot log on

Find the oracle installation directory rarr; db_1rarr; NETWORKrarr; ADMINrarr; modify the listener. ora file and tnsnames. ora notepad to open and find them.

Find the oracle installation directory rarr; db_1rarr; NETWORKrarr; ADMINrarr; modify the listener. ora file and tnsnames. ora notepad to open and find them.

1. Oracle client Configuration

1. find the oracle installation directory → db_1 → NETWORK → ADMIN → modify the listener. ora file and tnsnames. open ora notepad and check whether the host is the host name of the current computer. If not, change it to the current host name. If yes, skip this operation.

2. Start → all programs find the client files (My is Oracle-clientlient10g_home1) → select Enterprise Manager Console → go to Enterprise Manager to delete the original default database.

3. Restart OracleOraDb10g_home1TNSListener (listener) service.

4. log on to the Enterprise Manager again. Refer to the second step.

5. It will come up with a form for you to create a database. It consists of the following content:

① Host Name: enter your current host name, which must be the current host name and be the host name in the first two files.

② SID: the global database name. Some are ORA and some are ORCL. Enter the global database name you entered during installation

6. The creation is successful (before that, make sure that the oracle service is started .)

After successful creation, you can log on to the enterprise management Meta to create tablespaces and create users to manage databases.

Ii. system super Administrator Logon Failure (server SQL Plus logon and client logon)

In some cases, sys prompts you that you cannot connect to the database even though the password and account are correct.

This is not a big problem. The main reason is that the password has format requirements. You will know it when I create an instance. Hypothesis:

Username: sys password: 123

In this way, an error will be reported during logon.

You only need to change the password to 123 space as space sysdba to log on (the space here must be included)