oracle安装完成后的信息
oracle安装完成后的信息
Enterprise Manager Database Control URL - (orcl) :
http://PC-20120503DVQT:1158/em
数据库配置文件已经安装到 F:\oracle2\product\10.2.0,同时其他选定的安装组件也已经安装到 F:\oracle2\product\10.2.0\db_2。
iSQL*Plus URL 为:
http://PC-20120503DVQT:5560/isqlplus
iSQL*Plus DBA URL 为:
http://PC-20120503DVQT:5560/isqlplus/dba
附:orcl控制台网页创建表空间和添加用户自动生成的sql
1、新建表空间
CREATE SMALLFILE TABLESPACE "PORTAL" DATAFILE 'F:\ORACLE2\PRODUCT\10.2.0\ORADATA\ORCL\portal' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
2、新建用户
CREATE USER "PORTAL_USER" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "PORTAL" ACCOUNT UNLOCK
GRANT "CONNECT" TO "PORTAL_USER"
GRANT "DBA" TO "PORTAL_USER"
GRANT "RESOURCE" TO "PORTAL_USER"