1

Topic: I try to lift 1st time standby

All greetings, I try to lift 1st time standby, on one of stages there is an error:
...
SQL> create spfile from pfile ='c:/app/data/backup/pfilePROD.ora ';
create spfile from pfile ='c:/app/data/backup/pfilePROD.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 255 found in the input file
Contained pfilePROD.ora
[sub]
test. __ db_cache_size=109051904
test. __ java_pool_size=4194304
test. __ large_pool_size=4194304
test. __ oracle_base ='C:\app'#ORACLE_BASE set from environment
test. __ pga_aggregate_target=150994944
test. __ sga_target=281018368
test. __ shared_io_pool_size=0
test. __ shared_pool_size=155189248
test. __ streams_pool_size=0
*.audit_file_dest ='C:\app\admin\test\adump'
*.audit_trail ='db'
*.compatible = ' 11.2.0.0.0'
*.control_files ='C:\app\oradata\test\control01.ctl ', ' C:\app\flash_recovery_area\test\control02.ctl'
*.db_block_size=8192
*.db_domain ="
*.db_name ='test'
*.db_recovery_file_dest ='C:\app\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest ='C:\app'
*.dispatchers = ' (PROTOCOL=TCP) (SERVICE=testXDB)'
*.memory_target=428867584
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile ='EXCLUSIVE'
*.undo_tablespace ='UNDOTBS1'
# These parameters are necessary for us for operation in modes PRIMARY and STANDBY
db_name ='test'
db_unique_name ='testprod'
log_archive_config ='dg_config = (testprod, teststan)'
log_archive_dest_1 ='SERVICE=teststan LGWR ASYNC VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name=teststan ' log_archive_dest_2 ='LOCATION=c:/app/oradata/test/archive VALID_FOR = (ALL_LOGFILES, ALL_ROLES) db_unique_name=testprod'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
# These parameters are necessary for us for operation only in mode STANDBY
fal_client ='testprod'
fal_server ='teststan'
standby_file_management ='AUTO'
[/sub]

2

Re: I try to lift 1st time standby

necboss;
You it is casual not spfile with  took away?
Or in the instruction was not as from spfile to make pfile?

3

Re: I try to lift 1st time standby

Passed by...;
Before was it is created pfilePROD.ora
SQL> create pfile ='c:/app/data/backup/pfilePROD.ora ' from spfile;
Further under the instruction it is required to add a file in dop parameters and to restart the basis with new parameters and to create new spfile on the basis of processed pfile.

4

Re: I try to lift 1st time standby

Russian letters remove (even in comments)
Or it is correct NLS_LANG  (according to the coding of these Russian beeches)

5

Re: I try to lift 1st time standby

Now it is necessary to copy a file of passwords ($ORACLE_HOME/dbs/orapw$ORACLE_SID) from a primary server on standby.
But at me windows how on it the file of passwords is called?

6

Re: I try to lift 1st time standby

necboss wrote:

Now it is necessary to copy a file of passwords ($ORACLE_HOME/dbs/orapw$ORACLE_SID) from a primary server on standby.
But at me windows how on it the file of passwords is called?

%ORACLE_HOME %\database\PWD%ORACLE_SID %. ora
SY.

7

Re: I try to lift 1st time standby

On standbysrv I get listener.ora and tnsnames.ora

wrote:

# listener.ora Network Configuration File: C:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = teststan)
(ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
(SID_NAME = test)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = standbysrv) (PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app

I try to restart listener  errors:

wrote:

C:\app\product\11.2.0\dbhome_1\BIN> LSNRCTL stop
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 28-FEB-2018 09:33
:42
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL=IPC) (KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP) (HOST=standbysrv) (PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

8

Re: I try to lift 1st time standby

With  understand in listener.ora

9

Re: I try to lift 1st time standby

necboss wrote:

I try to restart listener  errors:

wrote:

LSNRCTL stop

Well I see only attempt to stop. And whether it has been launched?
The command start that speaks?

10

Re: I try to lift 1st time standby

Q.Tarantino;

wrote:

C:\app\product\11.2.0\dbhome_1\BIN> LSNRCTL start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 28-FEB-2018 18:33
:29
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\app\product\11.2.0\dbhome_1\network\admin\listener.o
ra
Log messages written to c:\app\diag\tnslsnr\standbysrv\listener\alert\log.xml
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=ipc) (PIPENAME = \. \PIPE\EXTPROC1521
ipc)))
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp) (HOST=standbysrv) (PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string
Listener failed to start. See the error message (s) above...

11

Re: I try to lift 1st time standby

necboss;
Well Vyacheslav means was not mistaken smile