walkerdba
asked on
stand by
I create all the steps to create standy database..
when I connected the standby database,,
I see this..
Can you please help..
[oracle@term admin]$
[oracle@term admin]$ . oraenv stand
ORACLE_SID = [stand] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracl e/product/ 11.2.0/db_ 1 is /u01/app/oracle
[oracle@term admin]$ sqlplus sys/oracle@stand as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 5 12:41:07 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
I don't know the sys password
why the error is like this
when I connected the standby database,,
I see this..
Can you please help..
[oracle@term admin]$
[oracle@term admin]$ . oraenv stand
ORACLE_SID = [stand] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracl
[oracle@term admin]$ sqlplus sys/oracle@stand as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 5 12:41:07 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
I don't know the sys password
why the error is like this
Hi,
It seems that you mix the ORACLE_SID used for local connection with the service name (using a @ connection string) to connect through the listener.
Regards,
Franck.
It seems that you mix the ORACLE_SID used for local connection with the service name (using a @ connection string) to connect through the listener.
Regards,
Franck.
>>to connect through the listener
Missed that.
Do you need to connect remotly? If you are on the server with the standby do this: sqlplus / as sysdba
Also, as soon as oracle sees 'as sysdba' on a local connection, in most cases, the username and password doesn't matter. You connect as SYS. It uses the password file with your OS user.
Missed that.
Do you need to connect remotly? If you are on the server with the standby do this: sqlplus / as sysdba
Also, as soon as oracle sees 'as sysdba' on a local connection, in most cases, the username and password doesn't matter. You connect as SYS. It uses the password file with your OS user.
ASKER
This is tnsnamesora from term machine where standby resides
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11 .2.0/dbhom e_1/networ k/admin/tn snames.ora
# Generated by Oracle configuration tools.
PRIM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prim)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
STAND =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stand)
)
)
This is tnsnames.ora from term1 machine where primary database resides
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11 .2.0/dbhom e_1/networ k/admin/tn snames.ora
# Generated by Oracle configuration tools.
PRIM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prim)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
STAND =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stand)
)
)
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --
This is initstand.ora from the machine where standby database is created..
stand.__db_cache_size=2642 41152
stand.__java_pool_size=419 4304
stand.__large_pool_size=41 94304
stand.__oracle_base='/u01/ app/oracle '#ORACLE_B ASE set from environment
stand.__pga_aggregate_targ et=1593835 52
stand.__sga_target=4781506 56
stand.__shared_io_pool_siz e=0
stand.__shared_pool_size=1 92937984
stand.__streams_pool_size= 4194304
*.audit_file_dest='/u01/ap p/oracle/a dmin/stand /adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/ oracle/ora data/stand /control01 .ctl','/u0 1/app/orac le/flash_r ecovery_ar ea/stand/c ontrol02.c tl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='pr im/prim',' stand/stan d'
*.db_name='prim'
*.db_recovery_file_dest='/ u01/app/or acle/flash _recovery_ area'
*.db_recovery_file_dest_si ze=4039114 752
*.diagnostic_dest='/u01/ap p/oracle'
*.dispatchers='(PROTOCOL=T CP) (SERVICE=standXDB)'
*.fal_client='stand'
*.fal_server='prim'
*.log_archive_config='dg_c onfig=(sta nd,stand)'
*.log_archive_dest_1='loca tion=/u01/ app/oracle /stand/arc hive valid_for=(all_logfiles,al l_roles) db_unique_name=stand'
*.log_archive_dest_2='serv ice=prim valid_for=(online_logfile, standary_r ole) db_unique_name=stand'
*.log_file_name_convert='p rim/prim', 'stand/sta nd'
*.open_cursors=300
*.pga_aggregate_target=158 334976
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.sga_target=476053504
*.standby_file_management= 'AUTO'
*.undo_tablespace='UNDOTBS 1'
*.db_unique_name=stand
This is initprim.ora from term1 machine
prim.__db_cache_size=26424 1152
prim.__java_pool_size=4194 304
prim.__large_pool_size=419 4304
prim.__oracle_base='/u01/a pp/oracle' #ORACLE_BA SE set from environment
prim.__pga_aggregate_targe t=15938355 2
prim.__sga_target=47815065 6
prim.__shared_io_pool_size =0
prim.__shared_pool_size=19 2937984
prim.__streams_pool_size=4 194304
*.audit_file_dest='/u01/ap p/oracle/a dmin/prim/ adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/ oracle/ora data/prim/ control01. ctl','/u01 /app/oracl e/flash_re covery_are a/prim/con trol02.ctl '
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='st and/stand' ,'prim/pri m'
*.db_name='prim'
*.db_recovery_file_dest='/ u01/app/or acle/flash _recovery_ area'
*.db_recovery_file_dest_si ze=4039114 752
*.diagnostic_dest='/u01/ap p/oracle'
*.dispatchers='(PROTOCOL=T CP) (SERVICE=primXDB)'
*.fal_client='prim'
*.fal_server='stand'
*.log_archive_config='dg_c onfig=(pri m,stand)'
*.log_archive_dest_1='loca tion=/u01/ app/oracle /prim/arch ive valid_for=(all_logfiles,al l_roles) '
*.log_archive_dest_2='serv ice=stand valid_for=(online_logfile, primary_ro le) db_unique_name=stand '
*.log_file_name_convert='s tand/stand ','prim/pr im'
*.open_cursors=300
*.pga_aggregate_target=158 334976
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.sga_target=476053504
*.standby_file_management= 'AUTO'
*.undo_tablespace='UNDOTBS 1'
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11
# Generated by Oracle configuration tools.
PRIM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prim)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
STAND =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stand)
)
)
This is tnsnames.ora from term1 machine where primary database resides
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11
# Generated by Oracle configuration tools.
PRIM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prim)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
STAND =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = term1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stand)
)
)
--------------------------
This is initstand.ora from the machine where standby database is created..
stand.__db_cache_size=2642
stand.__java_pool_size=419
stand.__large_pool_size=41
stand.__oracle_base='/u01/
stand.__pga_aggregate_targ
stand.__sga_target=4781506
stand.__shared_io_pool_siz
stand.__shared_pool_size=1
stand.__streams_pool_size=
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='pr
*.db_name='prim'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.fal_client='stand'
*.fal_server='prim'
*.log_archive_config='dg_c
*.log_archive_dest_1='loca
*.log_archive_dest_2='serv
*.log_file_name_convert='p
*.open_cursors=300
*.pga_aggregate_target=158
*.processes=150
*.remote_login_passwordfil
*.sga_target=476053504
*.standby_file_management=
*.undo_tablespace='UNDOTBS
*.db_unique_name=stand
This is initprim.ora from term1 machine
prim.__db_cache_size=26424
prim.__java_pool_size=4194
prim.__large_pool_size=419
prim.__oracle_base='/u01/a
prim.__pga_aggregate_targe
prim.__sga_target=47815065
prim.__shared_io_pool_size
prim.__shared_pool_size=19
prim.__streams_pool_size=4
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='st
*.db_name='prim'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.fal_client='prim'
*.fal_server='stand'
*.log_archive_config='dg_c
*.log_archive_dest_1='loca
*.log_archive_dest_2='serv
*.log_file_name_convert='s
*.open_cursors=300
*.pga_aggregate_target=158
*.processes=150
*.remote_login_passwordfil
*.sga_target=476053504
*.standby_file_management=
*.undo_tablespace='UNDOTBS
You have the same server configured in the tnsnames.ora file for stand and prim.
So is the stand database server configured as term1.localdomain?
Make sure term1.localdomain resolves to the correct IP address.
You also didn't post what happened if you didn't try a network connection with: sqlplus / as sysdba
So is the stand database server configured as term1.localdomain?
Make sure term1.localdomain resolves to the correct IP address.
You also didn't post what happened if you didn't try a network connection with: sqlplus / as sysdba
ASKER
machines pinging each other fine..
here is the real startup in standby location....
[oracle@term ~]$ export ORACLE_SID=stand
[oracle@term ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 5 18:36:14 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
SQL>
here is the real startup in standby location....
[oracle@term ~]$ export ORACLE_SID=stand
[oracle@term ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 5 18:36:14 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
SQL>
>>machines pinging each other fine..
You really shouldn't have the machines have the same name... it might cause you problems down the road.
>>ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Looks like this parameter isn't correct. Double check the steps you followed to make sure you didn't miss something.
I've never set up a standby database so I'm not sure what this should be set to. If you can provide a link to the steps you followed, I can take a look at them.
You really shouldn't have the machines have the same name... it might cause you problems down the road.
>>ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Looks like this parameter isn't correct. Double check the steps you followed to make sure you didn't miss something.
I've never set up a standby database so I'm not sure what this should be set to. If you can provide a link to the steps you followed, I can take a look at them.
ASKER
[oracle@term dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 08:14:02 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 477073408 bytes
Fixed Size 1337324 bytes
Variable Size 205522964 bytes
Database Buffers 264241152 bytes
Redo Buffers 5971968 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 08:14:02 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 477073408 bytes
Fixed Size 1337324 bytes
Variable Size 205522964 bytes
Database Buffers 264241152 bytes
Redo Buffers 5971968 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
>>ORA-00205: error in identifying control file, check alert log for more info
From the init file you posted, you have:
*.control_files='/u01/app/ oracle/ora data/stand /control01 .ctl','/u0 1/app/orac le/flash_r ecovery_ar ea/stand/c ontrol02.c tl'
Make sure the control files exist in those locations and are named as specified. Also make sure they are owned by the oracle user.
From the init file you posted, you have:
*.control_files='/u01/app/
Make sure the control files exist in those locations and are named as specified. Also make sure they are owned by the oracle user.
ASKER
what is wrong here
What is wrong here?
[oracle@term dbs]$ export ORACLE_SID=stand
[oracle@term dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 09:27:15 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
SQL>
stand.__db_cache_size=2642 41152
stand.__java_pool_size=419 4304
stand.__large_pool_size=41 94304
stand.__oracle_base='/u01/ app/oracle '#ORACLE_B ASE set from environment
stand.__pga_aggregate_targ et=1593835 52
stand.__sga_target=4781506 56
stand.__shared_io_pool_siz e=0
stand.__shared_pool_size=1 92937984
stand.__streams_pool_size= 4194304
*.audit_file_dest='/u01/ap p/oracle/a dmin/stand /adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/ oracle/ora data/stand /control01 .ctl','/u0 1/app/orac le/flash_r ecovery_ar ea/stand/c ontrol02.c tl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='or adata/prim ','oradata /stand'
*.db_name='prim'
*.db_recovery_file_dest='/ u01/app/or acle/flash _recovery_ area'
*.db_recovery_file_dest_si ze=4039114 752
*.diagnostic_dest='/u01/ap p/oracle'
*.dispatchers='(PROTOCOL=T CP) (SERVICE=standXDB)'
*.fal_client='stand'
*.fal_server='prim'
*.log_archive_config='dg_c onfig=(pri m,stand)'
*.log_archive_dest_1='loca tion=/u01/ app/oracle /prim/arch ive valid_for=(all_logfiles,al l_roles) db_unique_name=stand'
*.log_archive_dest_2='serv ice=prim valid_for=(online_logfile, primary_role) db_unique_name=prim'
*.log_file_name_convert='/ oradata/pr im','/orad ata/stand'
*.open_cursors=300
*.pga_aggregate_target=158 334976
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.sga_target=476053504
*.standby_file_management= 'AUTO'
*.undo_tablespace='UNDOTBS '
*.db_unique_name=stand
What is wrong here?
[oracle@term dbs]$ export ORACLE_SID=stand
[oracle@term dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 09:27:15 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
SQL>
stand.__db_cache_size=2642
stand.__java_pool_size=419
stand.__large_pool_size=41
stand.__oracle_base='/u01/
stand.__pga_aggregate_targ
stand.__sga_target=4781506
stand.__shared_io_pool_siz
stand.__shared_pool_size=1
stand.__streams_pool_size=
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='or
*.db_name='prim'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.fal_client='stand'
*.fal_server='prim'
*.log_archive_config='dg_c
*.log_archive_dest_1='loca
*.log_archive_dest_2='serv
*.log_file_name_convert='/
*.open_cursors=300
*.pga_aggregate_target=158
*.processes=150
*.remote_login_passwordfil
*.sga_target=476053504
*.standby_file_management=
*.undo_tablespace='UNDOTBS
*.db_unique_name=stand
Take a good look at the setting for log_archive_dest_1 in your pfile:
*.log_archive_dest_1='loca tion=/u01/ app/oracle /prim/archive
*.log_archive_dest_1='loca
ASKER
Change
*.log_archive_dest_1='loca tion=/u01/ app/oracle /prim/arch ive
to what?
*.log_archive_dest_1='loca
to what?
>>to what?
The correct PATH where you want them to go. Did you notice it still referenced 'prim' ( I bolded it in my last post)?
The correct PATH where you want them to go. Did you notice it still referenced 'prim' ( I bolded it in my last post)?
ASKER
Sir the question is do we need to create
/u01/app/oracle/prim/archi ve this path in standby machine...(this is from primary)
I have already this path in primay database machine...
I have this path now in my standby machine.
/u01/app/oracle/stand/stan d/arch
/u01/app/oracle/prim/archi
I have already this path in primay database machine...
I have this path now in my standby machine.
/u01/app/oracle/stand/stan
For log_archive_dest_1 on the stand machine, I would expect it to be set to the stand folder.
Remember, I've never set up a standby database so I'm not sure if you need another log_archive_dest_n set to point to where the prim archived logs are placed.
The guide you are following to set this all up should have covered the specifics for this.
Remember, I've never set up a standby database so I'm not sure if you need another log_archive_dest_n set to point to where the prim archived logs are placed.
The guide you are following to set this all up should have covered the specifics for this.
ASKER
Is there any way to solve this issue...
>>Is there any way to solve this issue...
Which issue? You have covered several different issues here.
Which one is still outstanding?
I also asked for the link/doc you used to create the standby back up in http:#a38859311. I'm thinking you missed a step or three.
Which issue? You have covered several different issues here.
Which one is still outstanding?
I also asked for the link/doc you used to create the standby back up in http:#a38859311. I'm thinking you missed a step or three.
ASKER
Both the nodes has these
[oracle@term stand]$ cd arch/
[oracle@term arch]$ pwd
/u01/app/oracle/stand/stan d/arch
[oracle@term arch]$
Where the standby going to be
This is where the primary is
[oracle@term1 stand]$ cd arch/
[oracle@term1 arch]$ pwd
/u01/app/oracle/stand/stan d/arch
[oracle@term1 arch]$
But still ,
[oracle@term arch]$ . oraenv
ORACLE_SID = [stand] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracl e/product/ 11.2.0/db_ 1 is /u01/app/oracle
[oracle@term arch]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 7 16:40:18 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
SQL>
[oracle@term stand]$ cd arch/
[oracle@term arch]$ pwd
/u01/app/oracle/stand/stan
[oracle@term arch]$
Where the standby going to be
This is where the primary is
[oracle@term1 stand]$ cd arch/
[oracle@term1 arch]$ pwd
/u01/app/oracle/stand/stan
[oracle@term1 arch]$
But still ,
[oracle@term arch]$ . oraenv
ORACLE_SID = [stand] ? stand
The Oracle base for ORACLE_HOME=/u01/app/oracl
[oracle@term arch]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 7 16:40:18 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
SQL>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes
http://ora-12545.ora-code.com/
If the ORACLE_HOME is correct: /u01/app/oracle/product/11
Can you post your tnsnames.ora file from:
/u01/app/oracle/product/11