1. Use Net8 Easy Config to configure the tnsnames.ora file. Create a service to the db. It will prompt you to enter the db_name, protocol, port (leave to 1521), hostname. Then connect to the server.
2. Yes the db has to be running.