The first time to install Oracle yourself, before the Oracle installation configuration is not in the past, finally fix, summed up.
1. Install oracle10g server side
2, install oracle10g client. The server side and client are not necessarily installed on the same machine.
3, start the server-side netconfiguration Assistant, configure the Listener
4. Create a database using the Databaseconfiguration Assistant Wizard
5, install Pl/sqldeveloper.
6. Configuring the client's Tnsnames.ora file
7. Open Pl/sqldeveloper, login test
The first three steps are easy, just follow the wizard's instructions. The fourth step to create the database is also very simple, if there is no special settings, but also follow the wizard instructions.
The fifth step, I use the green version, free installation, here need some configuration.
1, open the program, do not log in, enter the program.
2. In connection in Tools-preference, configure Oraclehome and OCI with the path to the instantclient path in the corresponding Oracle client, such as "D:\oracle\product\10.2.0 \client_1\instantclient ".
3. Modify the Tnsnames.ora file under D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN under Oracle client, similar to
ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.35.157) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Extproc_connection_data=
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY =extproc0))
)
(Connect_data =
(SID = Plsextproc)
(PRESENTATION = RO)
)
)
The basic only need to modify the red label, respectively, the name of the database service and the Oracle Server host address.
1. Create a new Network\admin folder under D:\oracle\product\10.2.0\client_1\instantclient\, and copy the Tnsnames.ora above.
2, open Pl/sqldeveloper again, select the database, enter the user name password login, you can.
After entering, you can use the system user to create a new user, table space, or datasheet, and configure roles and permissions, and then use a custom user login and do the relevant actions.
The above step is I after a period of time to summarize, the specific process if there are omissions and errors, please consult other relevant information.
Oracle Installation configuration Process