I have a question, probably a silly one for all the experienced Oracle DBA's but i am novice so forgive me if i asked a silly question. I just entered the world of oracle database administration from Ingres (????).
My question is "Do we have to have the same passwords for SYSTEM and SYS for both production and test database, when we are replicating a database from archive logs?. I am asking this because, we are actually applying the archive logs from the production database to the test database on an hourly basis. so does it require the passwords of test database SYS and SYSTEM be the same as production database SYS and SYSTEM or can they be different".
Please advice and thank you in advance for the help.