I am pretty new to Oracle database, and I am trying to set up a high availability between two PCs.
The first PC runs Windows server 2008 R2, and the second is on Fedora.
As far as I have read, with Oracle 11gr2, it is possible to do this.
I followed many tutorials, and reached the step when I need to start the standby database with the init file.
I get this error:
ORA-07202: sltln: invalid parameter to sltln.
I saw on some forums that it can come from a blank value for the parameter control_files, but this is not my case.
Here is the file :
franklin.__db_cache_size=922746880
franklin.__java_pool_size=16777216
franklin.__large_pool_size=16777216
franklin.__oracle_base='C:\Oracle'#Also tried : '/u01/app/oracle'
franklin.__pga_aggregate_target=1023410176
franklin.__sga_target=1526726656
franklin.__shared_io_pool_size=0
franklin.__shared_pool_size=536870912
franklin.__streams_pool_size=0
*.audit_file_dest='C:\Oracle\admin\franklin\adump'
# also tried '/u01/app/oracle/admin/franklin/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/franklinstby/PRIMCF.CTL'
*.db_block_size=8192
*.db_domain='exia'
*.db_name='franklin'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=franklinXDB)'
*.memory_target=2544893952
*.nls_language='FRENCH'
*.nls_territory='FRANCE'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/franklinstby/log_dest'
*.standby_file_management='AUTO'
*.core_dump_dest='/u01/app/oracle/admin/franklin/cdump'
*.db_file_name_convert='C:\oracle\oradata\franklin',
'/u01/app/oracle/oradata/franklinstby'
*.log_file_name_convert='C:\oracle\oradata\franklin',
'/u01/app/oracle/oradata/franklinstby'
The PRIMCF.CTL File is present.
---- Edit ----
Thanks to Phil, I advanced a step.
I now get this :
ORACLE instance started.
Total System Global Area 2538741760 bytes
Fixed Size 2216024 bytes
Variable Size 1593839528 bytes
Database Buffers 922746880 bytes
Redo Buffers 19939328 bytes
Base de donnees montee.
ORA-10458: standby database requires recovery
ORA-01157: impossible d'identifier ou de verrouiller le fichier de donnees 1 -
voir le fichier de trace DBWR
ORA-01110: fichier de donnees 1 : 'C:\ORACLE\ORADATA\FRANKLIN\SYSTEM01.DBF'
Translation from French to English is:
French: impossible d'identifier ou de verrouiller le fichier de donnees
English: impossible to identify or lock the data file
/at the start of the%_file_name_convertstring? – Phil Jun 29 '12 at 9:11*.diagnostic_dest=''or putting a valid path in – Phil Jun 29 '12 at 10:01