首先说明下环境,在linuxAS5上装的oracle,装了2个数据库,其中一个数据库已经使用,另外创建了一个数据库对其进行rman备份,两个数据库都可以用em的方式登录,毕竟端口不一样,但是isqlplus页面只能登录一个,另一个登录不了,oracle_sid已经修改了,
SQL> show parameter ins
以下是用sysdba登录打印的结果,
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 6 16:37:02 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter insNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string MMSS
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost bin]$ ORACLE_SID=rman; export ORACLE_SID
[oracle@localhost bin]$ ./sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 6 16:37:36 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter insNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string rman
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> quit
现在在用的是MMSS数据库,
两个数据库都可以用em登录,就是sqlplus rman的登录不了,我需要以system登录rman,创建用户,希望有人帮我,是不是sqlplus登录不同数据库需要不同端口。
SQL> show parameter ins
以下是用sysdba登录打印的结果,
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 6 16:37:02 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter insNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string MMSS
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost bin]$ ORACLE_SID=rman; export ORACLE_SID
[oracle@localhost bin]$ ./sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 6 16:37:36 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter insNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string rman
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> quit
现在在用的是MMSS数据库,
两个数据库都可以用em登录,就是sqlplus rman的登录不了,我需要以system登录rman,创建用户,希望有人帮我,是不是sqlplus登录不同数据库需要不同端口。
如果要特地使用一个数据库进行rman备份的话,还是建到另外一台机器上为好
指定库可以
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 7 09:44:08 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> quit;
Enter user-name: system
Enter password: Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL>
但是直接连可以,页面的会提示错误,从页面连的话直接可以明了的进入需要的SID,就是页面会报错
wildwave
(狂浪) #3楼 得分:0回复于:2010-08-06 21:51:29不能同时打开两个实例
如果要特地使用一个数据库进行rman备份的话,还是建到另外一台机器上为好 楼上,使用rman备份不能在同一台机器上进行么?有谁做过么,另外一台的话麻烦的,因为真实的环境是unix的环境,shell老是报错,unix双机的话麻烦的,需要ssh验证,现在linux上做测试的。哪位兄弟能有成功的做过rman的,帮一下,我mail:[email protected]。