1、你可以执行show parameter spfile查看,如果有路径,则使用的是spfile,同样你可以根据它知道 spfile的放置路径 2、一般为%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA3、你说的不是启动吧? 如何确定一个连接是DEDICAED还是SHARED SELECT sid , serial# , server FROM V$SESSION;当server列为dedicated时为专用连接,为shared时为共享连接 当server列为PSEUDO: alter system kill session is issued - the STATUS of the session object in V$SESSION becomes KILLED, its server becomes PSEUDO.SQL*Net MTS connections always appear as NONE or SHARED in the SERVER column of v$session view depending on whether or not a task is currently being serviced by a Shared Server. V$circuit view provides more detailed information about usage of circuits by each session. 如何配置成为SHARED服务器模式: 只要在参数文件中正确的配置了MTS_DISPATCHERS参数,该服务器就运行在SHARED服务器模式下: MTS_DISPATCHERS = “(PROTOCOL=TCP)(DISPATCHERS=3)( SERVICE= orcl.testserver.com)”如何配置成为DEDICATED: 在参数文件中没有配置MTS_DISPATCHERS参数,该服务器就运行在DEDICATED模式下:注意:在一个服务器配置成为SHARED服务器模式后,还可以建立到该共享服务器的专用连接,方法为: TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.37)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = xyj) ) )
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。Total System Global Area 122449892 bytes
Fixed Size 282596 bytes
Variable Size 88080384 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
ORA-00439: ?????: Real Application ClustersSQL> shutdown
ORA-01507: ??????ORACLE 例程已经关闭。把上面这个参数改回来后,启动的提示如下:
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。Total System Global Area 122449892 bytes
Fixed Size 282596 bytes
Variable Size 88080384 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
数据库装载完毕。
数据库已经打开。问题:怎样避免上述的错误呀
ORA-32004: obsolete and/or deprecated parameter(s) specified
可是我的运行环境变了呀!怎么才能得到原来内容的spfile呢?
再执行
startup pfile=你的参数文件
需要的话执行create spfile from pfile重建spfile文件
1、9i启动的命令startup,如果没有带参数,使用的是spfile参数文件吗?
2、一个数据库的spfile参数文件在磁盘上的什么位置呀?问题3:并行选件应该怎样设置,才能正常地进行设置和取消设置呀?
谢谢楼上的兄弟哈
spfile的放置路径
2、一般为%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA3、你说的不是启动吧?
如何确定一个连接是DEDICAED还是SHARED
SELECT sid , serial# , server FROM V$SESSION;当server列为dedicated时为专用连接,为shared时为共享连接
当server列为PSEUDO: alter system kill session is issued - the STATUS of the session object in V$SESSION becomes KILLED, its server becomes PSEUDO.SQL*Net MTS connections always appear as NONE or SHARED in the SERVER column of v$session view depending on whether or not a task is currently being serviced by a Shared Server. V$circuit view provides more detailed information about usage of circuits by each session.
如何配置成为SHARED服务器模式:
只要在参数文件中正确的配置了MTS_DISPATCHERS参数,该服务器就运行在SHARED服务器模式下:
MTS_DISPATCHERS = “(PROTOCOL=TCP)(DISPATCHERS=3)( SERVICE= orcl.testserver.com)”如何配置成为DEDICATED:
在参数文件中没有配置MTS_DISPATCHERS参数,该服务器就运行在DEDICATED模式下:注意:在一个服务器配置成为SHARED服务器模式后,还可以建立到该共享服务器的专用连接,方法为:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xyj)
)
)