ORACLE11g 我做了Create pfile from spfile;操作后,就无法找到SID了,我该如何做?
我做的操作,修改连接最大数:
Connect sys/orcl as sysdba;
Show parameter processes;
Alter system set processes=10000 scope=spfile;
Create pfile from spfile;
我知道ORACLE11G R2有一个BUG,如果不修改监听的HOST,只能在本机进行连接,后来我改为IP后也是好使的,但是我做了Create pfile from spfile;操作后,就无法找到SID了listener.ora监听 默认(HOST =127.0.0.1)后来改为168.1.192.159是好使的
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.1.192.159)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
tnsnames.ora监听
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =168.1.192.159)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
请高手帮帮忙
我做的操作,修改连接最大数:
Connect sys/orcl as sysdba;
Show parameter processes;
Alter system set processes=10000 scope=spfile;
Create pfile from spfile;
我知道ORACLE11G R2有一个BUG,如果不修改监听的HOST,只能在本机进行连接,后来我改为IP后也是好使的,但是我做了Create pfile from spfile;操作后,就无法找到SID了listener.ora监听 默认(HOST =127.0.0.1)后来改为168.1.192.159是好使的
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.1.192.159)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
tnsnames.ora监听
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =168.1.192.159)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
请高手帮帮忙
SQL> show parameters spfile;
看是否有返回正确的VALUE;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORACLE\PRODUCT\10.2.0\DB_1\
DATABASE\SPFILECW.ORA如果VALUE值不正确,而你已经备份了spfile,则在配置中把spfile的路径指定到正确的路径。