这里一定要点上噢
第一,关闭windows 防火墙,设置本地连接IP为192.168.1.66 子网255.255.255.0 网关192.168.1.1 202.101.224.69 202.101.226.68
第二,安装oracle10,注意出现360拦截时,选择允许。
选择高级安装,一路下一步,到数据库名称输入 fstest,不要更改。
一路下一步,到使用同一个密码处,勾选全部数据库使用相同密码 输入donglei.
安装过程比较长,先暂停。安装完成了。
第三,添加用户,设置权限登录用户名system密码donglei主机串fstest
执行下面的命令
create user tlbb IDENTIFIED BY iernei37d;
create user tl_gameuser IDENTIFIED BY iernei37d;
create user tlbb_read IDENTIFIED BY iernei37d;
执行下面的命令
第一部分
-- Grant/Revoke role privileges
grant connect to TLBB;
grant resource to TLBB;
-- Grant/Revoke system privileges
grant alter session to TLBB;
grant create cluster to TLBB;
grant create database link to TLBB;
grant create sequence to TLBB;
grant create session to TLBB;
grant create synonym to TLBB;
grant create table to TLBB;
grant create view to TLBB;
第二部分
-- Grant/Revoke role privileges
grant connect to tl_gameuser;
grant resource to tl_gameuser;
-- Grant/Revoke system privileges
grant alter session to tl_gameuser;
grant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
grant create sequence to tl_gameuser;
grant create session to tl_gameuser;
grant create synonym to tl_gameuser;
grant create table to tl_gameuser;
grant create view to tl_gameuser;
第三部分
-- Grant/Revoke role privileges
grant connect to tlbb_read;
grant resource to tlbb_read;
-- Grant/Revoke system privileges
grant alter session to tlbb_read;
grant create cluster to tlbb_read;
grant create database link to tlbb_read;
grant create sequence to tlbb_read;
grant create session to tlbb_read;
grant create synonym to tlbb_read;
grant create table to tlbb_read;
grant create view to tlbb_read;
这是给这三个用户授权。成功了,关闭
接下来是
导入OR的数据库
将tlbb.dmp tl_gameuser.dmp放在C盘下