ITPub博客

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = PC-2009)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1522)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )在原来的监听器中增加一个监听地址。[@more@]修改tnsnames.oraTEST2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = test2) ) )增加一网络服务名

在2.4.21中,用redhat-config-users进入在2.6.18中,用system-config-users进入,也可从图形界面的菜单进入,这样也是很方便的.[@more@]

1. This moment will nap, you will have a dream; but this moment study, you will interpret a dream. 此刻打盹，你将做梦；而此刻学习，你将圆梦。2. I leave uncultivated today, was precisely yesterday perishes tomorrow which person of the body implored. 我荒废的今日，正是昨日殒身之人祈求的明日。3. Thought is already is late, exactly is the earliest time. 觉得为时已晚的时候，恰恰是最早的时候。[@more@]4. Not matter of the today will drag tomorrow. 勿将今日之事拖到明日。5. Time the stu

默认的颜色有点淡, 有些要凑近了才看的清, 于是想更改成白底黑字的,Putty--> Window-->Colours-->General options for colour usage选中 Use system colours再进入Putty界面登录后,就成白底彩字了,还好，比以前看起来顺一点．[@more@]

安装之后要求更改管理员帐户密码Administrator字母加数字,过不了,重来小写字母加数字加大写字母,过看来要设置高强度的密码规则才让过啊.包含三种以上的密码格式............[@more@]

1.Run->gpedit.msc 2.Computer Config -> Administrative Template -> System 3.Double click Turn off Autoplay 4.Enable it. 5.Select All Drivers 6. Ok[@more@]

rowid 在toad中不显示,在sqlplus中才有显示.不知是不是因为toad设置的原因呢,还是其他原因.[@more@]

找了好久都没有找到七彩虹在linux64位下的驱动,出差一星期,回来后在网上搜到一个命令,redhat-config-xfree86试了一下,很灵的,因为作为应用的测式服务器,有个图形出来就行了,接下去就要测试DB与AP了.[@more@]

斯巴达300[@more@]

之前测试电脑上已经有一个oracle9201的数据库,在安装另一个测试库b后, 使用sqlplus会有ORA-27101 Shared memory realm does not existORA-12514:TNS:监听进程不能解析在连接描述符中给出的SERVICE_NAME还有TNS-12547:TNS:丢失连接查看listener 日志TNS-12514: TNS:监听进程不能解析连接描述符中给出的 SERVICE_NAME[@more@]解决过程查看sqsnet NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)查看tnsnames.ora,也没有问题, tnsping servicename也没有问题,查看listener状态,只检测到一个例程,重新载入,可以检测到二个例程,然后set oracle_sid