Oracle creation (basic)

I have never been familiar with Oracle. I have learned a lot from my brother's demonstration today, so I wrote this article to record it. Let's talk a little bit about the situation:

Environment: Windows2003 + oracle9i is installed in vpc2007 as the server. Host Name: MS-zy-Oracle; Database Name: MIS

Local Machine: WindowsXP + Oracle9i client,

After running the virtual machine, open Oracle's internal ice mangager and Log On As A system user. Next, configure:

1. Create a tablespace.

Click "Storage"> "tablespace" in enterprice mangager, right-click "CREATE", and enter the name and file size. You can also select the file path and click "CREATE" to create the tablespace.

2. Create a user.

In "security"-> "user" right-click "CREATE", enter the name and password, and select the tablespace you just created. on the Role tab, add "dba" to the role, and tick "Management Options" in "granted". Do not modify other options, click "CREATE" to create the user.

3. Connection

In the Oracle directory of the server, for example, "C:/Oracle/ora90/Network/admin/tnsnames. ora", open the file and find the connection string of the file:

MIS =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = MS-zy-Oracle) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = MIS)
)
)

Copy the file and find the same file "D:/Oracle/ora90/Network/admin/tnsnames" in the Oracle directory on the client. ora ", and then add the string copied on the server to the file. save, close.

4. Test.

We have configured the server connection on the client. At this time, we need to test whether the server can be connected. enter tnsping MIS in the command line to check whether MIS is available. if one (** millisecond) is returned, the connection is successful.

5. Create a table and write data.

In this case, you can use the client to access the Oracle server. we recommend that you use PLSQL, which is better than your Oracle client. there are many downloads online. after running PLSQL, enter the user name and password, select "mis" for the database, and connect to "normal". Then you can log in. right-click the table on the left and choose "New" to create a table. after the table is created, right-click the table and choose "editdata" to enter the data. the specific operations of PLSQL will not be discussed much. our Oracle database has been completed.