可乐150《天龙八部》服务端

系统：win2003   centos5.0     centos5.0和LINUX一样win2003步骤下载oracal。win32版的 用讯雷下载，这是在win2003上面安装的!http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip下载好后解压缩点setup.exe运行画面出来后点高级安装，然后一直下一步一直到所有帐号用同一个密码点所有帐号用同一个密码，方便管理！这里随便设安装好以后打开IE。输入http://127.0.0.1:5560/isqlplus用户名:system密码:设置你自己的连接符orcl（安装ORACLE时候的标识）优化ORACLE 页面进入（优化解决卡验证，修复下数据错误即可）http://127.0.0.1:1158/em然后在网页中间空白复制以下四段代码.每复制一段按一下执行，然后删除再复制下一段!create user tlbb IDENTIFIED BY iernei37d;create user tl_gameuser IDENTIFIED BY iernei37d;create user tlbb_read IDENTIFIED BY iernei37d;以上为第一段：最后面iernei37d分别为后面三个帐号的密码tlbb  tl_gameuser  tlbb_read-- Grant/Revoke role privilegesgrant connect to TLBB;grant resource to TLBB;-- Grant/Revoke system privilegesgrant 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 privilegesgrant connect to tl_gameuser;grant resource to tl_gameuser;-- Grant/Revoke system privilegesgrant 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 privilegesgrant connect to tlbb_read;grant resource to tlbb_read;-- Grant/Revoke system privilegesgrant 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;以上为第四段然后在win2003下导入dmp文件 开始--运行---输入cmdImp tlbb/iernei37d file=d:\tlbb.dmp ignore=yImp tl_gameuser/iernei37d file=d:\tl_gameuser.dmp ignore=y这里我设置是d盘 所以放到d盘 tlbb/后面这是刚才设置的密码你放在E盘tlbb里面就把d:\改成e:\tlbb\好了 到如成功然后运行plsqldevUsers——TL_gameuser--Objects--Tables--Userbase 编辑 权限被授予者tlbb yes yes yes yesUsers--tlbb 编辑权限被授予者tl_gameuser.seq_user_basic_uin yestl_gameuser.user_basic yes yes yes yes然后注销 登陆 tlbb  mugua2234Users--tlbb--OBJECTS--PROcedures编译下第一个oracle部分配置完成or在win 的部分就这么简单。031版本ORACLE增加字段SERVER_STATUS  char(1)  '1'REALNAME_BIND  char(1)  'N'CONFIRM_PROTOCOL char(1)  'N'密码必须：iernei37d以下是linux教程具体步骤装mysql装mysqlodbc   解压Linux下的精简版oracle传WIN2003的X:\oracle\product\10.2.0\db_1\NETWORK\ADMIN里tnsnames.ora到/home/instantclient_10_2文件夹里加系统变量传ini两个文件到根目录etc下配置修改/home/tlbb/Billing所有文件用scp上传到home目录里(二进制上传)二进制设置：scp里的选项--选项--传输，点二进制，再点确定！上传好以后用CRT连接LINUX机器装mysqlcd /home             ;进入home文件夹tar xzvf mysql-5.0.45.tar.gz    ;解压mysq。。ltar.gz解压这种格式命令tar xzvf 加文件名cd /home/mysql-5.0.45           ;进入home/mysql-5.0.45文件夹./configure  --prefix=/usr/local/mysql5.0.45 --with-charset=utf8 --with-extra-charsets=all --enable-thread-safe-client                     ;指定安装路径make                         ;时间较长make install                ;时间较长cp /usr/local/mysql5.0.45/share/mysql/my-small.cnf /etc/my.cnf        ;执行后选 Y 覆盖 别管乱码就按Y用winSCP3返回到根目录找到etc文件夹打开后找到my.cnf编辑加入在[mysqld] 和 [client]段都加入如下代码：default-character-set=utf8再返回到命令/usr/local/mysql5.0.45/bin/mysql_install_db/usr/local/mysql5.0.45/bin/mysqld_safe --user=root &    ;启动mysql服务用winSCP3返回到根目录找到etc文件夹找到re.d打开rc.local 把上面那个启动mysql加入进去!mysql -u root -p `进入mysql操作 密码为空直接回车确认use mysql; update user set Password=PASSWORD('bojie1976') where User='root'; `bojie1976为你要设置mysql管理员的密码.请记住然后 加下面两段代码insert into mysql.user (Host,  User,  Password,  Select_priv,  Insert_priv,  Update_priv,  Delete_priv,  Create_priv,  Drop_priv,  Reload_priv,  Shutdown_priv,  Process_priv,  File_priv,  Grant_priv,  References_priv,  Index_priv,  Alter_priv,  Show_db_priv,  Super_priv,  Create_tmp_table_priv,  Lock_tables_priv,  Execute_priv,  Repl_slave_priv,  Repl_client_priv,  Create_view_priv,  Show_view_priv,  Create_routine_priv,  Alter_routine_priv,  Create_user_priv,  ssl_type,  ssl_cipher,  x509_issuer,  x509_subject,  max_questions,  max_updates,  max_connections,  max_user_connections) value ('%', 'tlbb', PASSWORD('bojie1976'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);insert into mysql.user (Host,  User,  Password,  Select_priv,  Insert_priv,  Update_priv,  Delete_priv,  Create_priv,  Drop_priv,  Reload_priv,  Shutdown_priv,  Process_priv,  File_priv,  Grant_priv,  References_priv,  Index_priv,  Alter_priv,  Show_db_priv,  Super_priv,  Create_tmp_table_priv,  Lock_tables_priv,  Execute_priv,  Repl_slave_priv,  Repl_client_priv,  Create_view_priv,  Show_view_priv,  Create_routine_priv,  Alter_routine_priv,  Create_user_priv,  ssl_type,  ssl_cipher,  x509_issuer,  x509_subject,  max_questions,  max_updates,  max_connections,  max_user_connections) value ('%', 'tlbbtools', PASSWORD('bojie1976'), 'Y','Y','Y','Y','N','Y','N','N','N','N','N','Y','Y','N','N','N','Y','N','Y','N','N','Y','Y','N','N','N','','','','',0,0,0,0);flush privileges;create database tlbbdb;create database tlbbdb_stat;insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '%', 'tlbbdb','tlbb', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '%', 'tlbbdb','tlbbtools', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'Y');insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '%', 'tlbbdb_stat','tlbb', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');输入exit `退出mysql操作导入数据库：cd /homemysql -uroot -pbojie1976 tlbbdb < DBInit_0_31_0180_table_mysql.sql          ;bojie1976为你的mysql root密码mysql -uroot -pbojie1976 tlbbdb < DBInit_0_31_0180_data_mysql.sqlmysql -uroot -pbojie1976 tlbbdb_stat < tlbbdb_stat.sql               ;bojie1976为你的mysql root密码安装到这用sqlyoy企业测试连接！把sqlyoy里原有的连接都删掉，建新连接主机地址为你linux的IP帐号:tlbb密码:bojie1976测试连接成功！下面安装下数据源rpm -ivh mysql-connector-odbc-3.51.25-0.i386.rpm修改odbc.ini 复制到etc下接着增加系统变量用etc打开根目录etc/profile右键编辑在最下面加入下面代码export PATH=$PATH:/bin:/sbin:/home/instantclient_10_2export ORACLE_HOME=/home/instantclient_10_2export TNS_ADMIN=/home/instantclient_10_2export LD_LIBRARY_PATH=/home/instantclient_10_2:/home/tlbb/Billing:/home/tlbb/Server重启linux机器。用CRT连接root帐号登陆。输入reboot       ;reboot为linux重启命令重启好，接着配置服务端Billing用ect打开/home/tlbb/Billing/etc/db_hash.conf#散列表0：MAXDBCONNS0  = 5DBUSER_DB0  = tlbbDBPASS_DB0 = JC4KQ1EJP   ;JC4KQ1EJP 改成你在win机上导入四段代码中第一段第一行最后那个iernei37dDBTNS_DB0 = ora10g       ;ora10g改成win2003上的标识符orcl#DBUSER_DB1  = tlbb#DBPASS_DB1 = JC4KQ1EJP     ;JC4KQ1EJP 改成你在win机上导入四段代码中第一段第一行最后那个iernei37d#DBTNS_DB1 = ora10g         ;ora10g改成win2003上的标识符orcl好了，保存.再来下一个文件!用ect打开/home/tlbb/Billing/etc/gbs.confMAXCONNS        = 100                   #最大连接数  这里改成1000MAXDBCONNS_BILL      = 20DBUSER_GAMEBILL     = tlbbDBPASS_GAMEBILL     = JC4KQ1EJP    ;JC4KQ1EJP 改成你在win机上导入四段代码中第一段第一行最后那个iernei37dDBTNS_GAMEBILL      = ora10g        ;ora10g改成win2003上的标识符orcl#MAXDBCONNS_AUTH      = 20DBUSER_GAMEAUTH     = tl_gameuserDBPASS_GAMEAUTH     = SDHRFZVZ5    ;SDHRFZVZ5 改成你在win机上导入四段代码中第一段第二行最后那个iernei37dDBTNS_GAMEAUTH      = ora10g       ;ora10g改成win2003上的标识符orcl好了，保存，再来第三个文件用ect打开/home/tlbb/Billing/e

上一条：《天龙八部》一键安装版完整整理架设资料全集
下一条：《天龙八部》开服官方无错完整一条龙开区端