-
编辑 删除
SQL Sever 下更改数据文件位置
EXEC sp_helpfile -- 查询目前数据文件的名字和位置 --修改文件位置-- ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'H:TEMPDB_APSZDB01TempFile0_Data.NDF') GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'H:TEMPDB_APSZDB01TempLog_1.LDF') GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev2, FILENAME = 'H:TEMPDB_APSZDB01TempFile2_Data.NDF') GO[@more@]
-
编辑 删除
Linux 建立主机信任关系步骤
host11）chmod 755 /home/oracle; mkdir ~/.ssh; chmod 755 ~/.ssh2)/usr/bin/ssh-keygen -t rsa3)/usr/bin/ssh-keygen -t dsa4)cd /home/oracle/.ssh; cat id_rsa.pub >> authorized_keys; cat id_dsa.pub >> authorized_keys host21）chmod 755 /home/oracle; mkdir ~/.ssh; chmod 755 ~/.ssh2)/usr/bin/ssh-keygen -t rsa3)/usr/bin/ssh-keygen -t dsa4)cd /home/oracle/.ssh; cat id_rsa.pub >> authorized_keys; cat id_dsa.pub >> authorized_keys host1: ssh oracle@host2 cat ~/.ssh/id
-
编辑 删除
Sql Statement for create a new 10g database
Create database ocm1maxinstances 1maxloghistory 1maxlogfiles 36maxlogmembers 2maxdatafiles 256datafile '/rdsk/oradata/ocm1/system01.dbf' size 512M reuse autoextend on next 10M max 2048Mdefault temporary tablespace temp tempfile '/rdsk/oradata/ocm1/temp01.dbf' size 2048m reuse autoextned offextent management localsysaux datafile '/rdsk/oradata/ocm1/sysaux01.dbf' size 512M autoextned onundo tablespace undotbs1 datafile '/rdsk/oradata/ocm1/undotbs01.dbf' size 2048m reuse autoex
-
编辑 删除
Configure of Oracle 10g Listener
oracle listener 的配置： 动态注册 1）默认注册为LISTENER名为LISTENER,端口为15212) 注册的SERVICE名字来自INIT文件的SERVICE_NAME, instance来自INIT文件的instance_name3) 在TNSNAMES.ORA文件中配置LISTENER的名字，格式例可为： listener_s = (address= (protocol=tcp)(host=hostname)(port=port_number))4) 然后在数据库中，利用alter system set local_listener = listener_s则可以将数据库注册到动态监听器LISTENER_S5) 最好在数据库中设置好SERVICE_NAME和INSTANCE_NAME,这样数据库会自动注册到动态监听器。
-
编辑 删除
Oracle 10g DataGuard Configuration
1) primary.db_name=orcldb_unique_name=primarylog_archive_dest_2="service=standby lgwr async valid_for(online_logfiles,primary_role) db_unique_name=standby)fal_server=primaryfal_client=standbylog_archive_config='dg_config=(primary,standby)'standby_file_management=auto 2)standbydb_name=orcldb_unique_name=standbyfal_server=primaryfal_client=standbylog_archive_config='dg_config=(primary,standby)'standby_file_management_autodb_file_name_convert='/rdsk/oradata/primary','/rdsk/oradata/stand
-
编辑 删除
RAC 11GR2 in linux vmware
host1: racnode1host2: racnode2 modify /etc/hosts(both host)add racnode1,racode2,racnode1-priv,racnode2-priv,racnode1-vip,racnode2-vip set bind(DNS) in racnode1, add racnode-cluster-scan item in the DNS start/stop cluster root: /u01/app/11.2.0/grid/bin/crsctl start/stop cluster -n racnode1 (stop node1) -all (stop both nodes) /u01/app/11.2.0/grid/bin/crs_stat -t (view cluster status) start/stop database(instances)
