oracle建数据库

前端之家收集整理的这篇文章主要介绍了oracle建数据库前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

oracle用户界面登陆

用户要切换到oracle

sqlplus / as sysdba    //sys用户是oracle的最高管理员所以要加上as
help index //查看命令列表,sql中不区分大写小写 show user //查看当前用户
quit //退出sql

创建数据库

[[email protected] ~]$ dbca     //会自动跳转出,如果不弹窗口执行: export DISPLAY=:0.0

提示:No protocol specified,则输入

xhost local:oracle non-network local connections being added to access control list

敲回车运行后出现:

non-network local connections being added to access control list
xhost: bad hostname "non-network"
xhost: bad hostname "local"
xhost: bad hostname "connections"
xhost: bad hostname "being"
xhost: bad hostname "added"
xhost: bad hostname "to"
xhost: bad hostname "access"
xhost: bad hostname "control"
xhost: bad hostname "list"

此时再 输入 dbca,即可弹出图形界面

猜你在找的Oracle相关文章