情况:我新建了2个数据库共3个数据库
orcl
MR
MYDB
只有最新新建的MYDB正常连接(在未新建MYDB的时候,新建完MR的时候,只有MR能正常连接,也是无法启动orcl)现在其余了两个orcl、MR
sqlplus sys/111111111@MR as sysdba
提示已连接到空闲例程startup启动数据库
ORA-01078
LRM-00109貌似是spfile文件的问题,找不到spfile文件,但spfile文件确实存在,并且没有改动过尝试使用pfile文件启动数据库
C:\ORACLE\1.0\admin\MR\pfile\init.ora.24201821247
但出现ORA-00205请求帮忙啊啊啊啊啊
orcl
MR
MYDB
只有最新新建的MYDB正常连接(在未新建MYDB的时候,新建完MR的时候,只有MR能正常连接,也是无法启动orcl)现在其余了两个orcl、MR
sqlplus sys/111111111@MR as sysdba
提示已连接到空闲例程startup启动数据库
ORA-01078
LRM-00109貌似是spfile文件的问题,找不到spfile文件,但spfile文件确实存在,并且没有改动过尝试使用pfile文件启动数据库
C:\ORACLE\1.0\admin\MR\pfile\init.ora.24201821247
但出现ORA-00205请求帮忙啊啊啊啊啊
2、你是如何添加数据库的。
我是用Database Configuration Assistant添加数据库的
然后没有监听
我在tnsnames添加监听
ALERT LOG和tnsnames详见下面记录ALERT LOG:2018-03-08T18:55:59.988902+08:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\Administrator\virtual\product\12.2.0\dbhome_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2018-03-08T18:56:04.817564+08:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
NUMA system with 2 nodes detected
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
Windows NT Version V6.2
ORACLE_HOME = C:\app\Administrator\virtual\product\12.2.0\dbhome_1
Node name : WIN-GO2IT0E74E3
CPU : 2 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:
VM name : VMWare Version (6)
Using parameter settings in client-side pfile C:\APP\ADMINISTRATOR\VIRTUAL\ADMIN\MYDB\PFILE\INIT.ORA on machine WIN-GO2IT0E74E3
System parameters with non-default values:
processes = 300
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
sga_target = 1904M
control_files = "C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\MYDB\CONTROL01.CTL"
control_files = "C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\MYDB\CONTROL02.CTL"
db_block_size = 8192
compatible = "12.2.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=MYDBXDB)"
local_listener = "LISTENER_MYDB"
audit_file_dest = "C:\APP\ADMINISTRATOR\VIRTUAL\ADMIN\MYDB\ADUMP"
audit_trail = "DB"
db_name = "MYDB"
open_cursors = 300
pga_aggregate_target = 631M
diagnostic_dest = "C:\APP\ADMINISTRATOR\VIRTUAL"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)2018-03-08T18:55:59.988902+08:00
All SGA segments were allocated at startup
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\app\Administrator\virtual\product\12.2.0\dbhome_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2018-03-08T18:56:04.817564+08:00
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
NUMA system with 2 nodes detected
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.
Windows NT Version V6.2
ORACLE_HOME = C:\app\Administrator\virtual\product\12.2.0\dbhome_1
Node name : WIN-GO2IT0E74E3
CPU : 2 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:
VM name : VMWare Version (6)
Using parameter settings in client-side pfile C:\APP\ADMINISTRATOR\VIRTUAL\ADMIN\MYDB\PFILE\INIT.ORA on machine WIN-GO2IT0E74E3
System parameters with non-default values:
processes = 300
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
sga_target = 1904M
control_files = "C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\MYDB\CONTROL01.CTL"
control_files = "C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\MYDB\CONTROL02.CTL"
db_block_size = 8192
compatible = "12.2.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=MYDBXDB)"
local_listener = "LISTENER_MYDB"
audit_file_dest = "C:\APP\ADMINISTRATOR\VIRTUAL\ADMIN\MYDB\ADUMP"
audit_trail = "DB"
db_name = "MYDB"
open_cursors = 300
pga_aggregate_target = 631M
diagnostic_dest = "C:\APP\ADMINISTRATOR\VIRTUAL"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)tnsnames.oraLISTENER_MYDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.188.91.128)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.188.91.128)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
)
)MR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.188.91.128)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MR)
)
)LISTENER_MR =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.188.91.128)(PORT = 1521))
而 SQL SERVER, 一个实例下可以建多个数据库。
12c下,如果想建多个库,需要先建个 container db,然后在其下就可以建多个 Pluggable DB了。