oracle 11G创建数据库步骤

admin2022-10-1113120

1

Bash
[oracle@rhel7 ~]$ dbca


image-20221010004206076.png


image-20221010004214736.png


image-20221010004246618.png



image-20221010004323210.png



image-20221010004859094.png


image-20221010005027222.png


image-20221010005129215.png


image-20221010005243089.png


image-20221010005324852.png



image-20221010005538310.png



image-20221010005631952.png


image-20221010005755107.png



image-20221010005901469.png



image-20221010010028581.png



image-20221010010132207.png



image-20221010005324852.png



image-20221010010201712.png


image-20221010010251862.png


image-20221010010818429.png


image-20221010011057034.png



image-20221010011259948.png



image-20221010011444297.png


image-20221010011533664.png


image-20221010011658040.png



image-20221010011841915.png


image-20221010011923750.png


image-20221010012010549.png


image-20221010012112353.png


image-20221010012149911.png


image-20221010012231129.png


image-20221010012311802.png



image-20221010012327853.png


image-20221010012424622.png


image-20221010012456381.png


image-20221010012523393.png



image-20221010012609511.png



image-20221010012637120.png



image-20221010012703969.png


image-20221010012734251.png


image-20221010012747257.png


image-20221010012902805.png


image-20221010012933604.png



image-20221010013100679.png


image-20221010013113615.png


image-20221010013204564.png



image-20221010013304418.png



image-20221010013414798.png



image-20221010013505181.png


image-20221010013525463.png


image-20221010013618704.png


image-20221010013654761.png


image-20221010013725323.png



image-20221010013743315.png


image-20221010013820659.png



image-20221010013820659.png


image-20221010013925117.png


接下来会弹出一个对话框来，对话框可能比较小，需要手动拖动放大

接下来会弹出一个对话框来，对话框可能比较小，需要手动拖动放大

接下来会弹出一个对话框来，对话框可能比较小，需要手动拖动放大

接下来会弹出一个对话框来，对话框可能比较小，需要手动拖动放大

这个对话框里面是创建数据库的基本信息

image-20221010014042351.png


image-20221010014202610.png


image-20221010014317855.png


image-20221010014355476.png



image-20221010014408332.png



image-20221010014420228.png


到这一步的时间比较久根据电脑的配置决定完成的时间

到这一步的时间比较久根据电脑的配置决定完成的时间

到这一步的时间比较久根据电脑的配置决定完成的时间

image-20221010014444841.png



image-20221010143145311.png



image-20221010143213715.png


image-20221010143837644.png



image-20221010143913403.png


到这一步我们的数据库就创建完成


查看状态

image-20221010145459673.png


登录格式：

Bash
sqlplus system/123456@edu
格式：
sqlplus [userbane]/[password]@[databases]


超级管理员的形式登录

Bash
[oracle@rhel7 ~]$ sqlplus "/as sysdba"

解释：
	sqlplus
		进数据库管理的工具
		
	"/as sysdba"
		超级管理员


image-20221010145926094.png


退出

SQL
SQL> exit


第二种进入数据库的方法

Bash
[oracle@rhel7 ~]$ sqlplus /nolog

image-20221010151041640.png


然后再登录到当前的数据库里面区

Bash
SQL> conn /as sysdba;

image-20221010151324714.png


通过监听登录

Bash
[oracle@rhel7 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-OCT-2022 15:15:06

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel7.6-1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                10-OCT-2022 00:34:13
Uptime                    0 days 14 hr. 40 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7.6-1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "edu" has 1 instance(s).
  Instance "edu", status READY, has 1 handler(s) for this service...
The command completed successfully


进入到目录里面/oracle/app/oracle/product/11.2.0/db_1/network/admin

Bash
[oracle@rhel7 ~]$ cd /oracle/app/oracle/product/11.2.0/db_1/network/admin


查看目录下的所有文件

Bash
[oracle@rhel7 admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora


image-20221010151706647.png


查看tnsnames.ora里面的内容

Bash
[oracle@rhel7 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EDU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rhel7.6-1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = edu)
    )
  )


利用tnsping命令ping一下edu这个库，最后显示ok说明是没有问题的

Bash
[oracle@rhel7 admin]$ tnsping edu

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 10-OCT-2022 15:19:41

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rhel7.6-1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = edu)))
OK (0 msec)

从这里面可以看到一些信息
	HOST = rhel7.6-1
		主机名称
		
	PORT = 1521
		监听的端口
	
	SERVICE_NAME = edu	
		服务名


登录

Bash
[oracle@rhel7 admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 10 15:23:44 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn sys/123456@edu as sysdba;
















































































































































Powered By Z-BlogPHP 1.7.4

 Theme By 优美模版

本博客为开源博客，本博客联系QQ：372097243