In production DB we take cold backups. I wanted to restore this cold backup to test machine which has 4 DB's already.
I managed to open database but i'm confused with listener. When i write "lsnrctl start LIVE" int gives error because it's looking for the LIVE machine's IP and port number. I tried to edit listener.ora file but i couldn't managed to open the listener. What should i do to open this listener?
Could you explain how should i work with multiple oracle homes, multiple oracle users on UNIX.