Oracle BASIC operations 1 new database

first, the new database1. Create a new database.

1.1 Open the Database Configuration Assistant;

1.2 Select New Database, Next, choose the first "general purpose or thing processing";

1.3 Give the database a name, which is the unique identifier. (the "Database name" required when logging in);

1.4 Tick off the relevant options for enterprise Manager, and automatic maintenance tasks.

1.5 Use the same admin password for all accounts, enter "NARISQ" (the password required when logging in, User name defaults to system)

1.6 Storage Location Select a third, default app location. You can also select a second and manually select a location.

1.7 The recovery area is selected by default.

1.8 Initialization parameters.

Memory: Select "Customize". Only a few visits, fill 160,16 separately. Add up to 200M.

Character Set: note whether the national character set is UTF-16, the next step.

1.9 All the way next – complete, pop up the confirmation window and click OK.

1.10 Start the database creation.

Created successfully.

2. Configuring the Listening port

2.1 Open the NET configuration Assistant and select the listener configuration.

2.2 Select the "Add" listener to set the listener name.

2.3 The next step. Listening port number Select the default 1521 (this port is the default for Oracle). Proceed to the next step and finish.

3. Configure Network Services

Say two words: Theoretically, the database is new, and when the listening port is configured, the following services are automatically displayed in Net Manager.

However, there are times, no this service appears, I do not know why, only know, this time to configure their own services. Also very simple.

3.1 Open NET Configuration Assistant, select "Local Network Service name Configuration"

3.2 Select "Add"

3.3 Enter the service name, consistent with the database name

3.4 The Access Protocol defaults to "TCP"

3.5 This step is important. If it is native, enter localhost/natively IP address/native computer name, all can;

If you are connecting to another computer's database, enter the IP address of the machine.

3.6 Test. A successful connection appears stating that the service configuration was successful.

3.6-2 if not successful. Click Change login, manually change the password. Consistent with the password for the new database.

Well, then there's nothing to say. Let's go.

Second, delete the database1. Delete the database.

Open the Database Configuration Assistant and delete it. The steps are as follows:

　　

2. Remove the listener that is associated with the database.

2.1 Open the NET configuration Assistant and select the listener configuration.

2.2 Select "Delete" and select the listener you want to delete.

Oracle BASIC operations 1 new database