I have a fresh installation of Oracle 11g database on Windows Server 2008. I want the database to be accessed remotely by users (may be via client EM or something else appropriate). Users are expected to fire queries, create table, etc in the tablespace allocated to them. If they are outside campus they must VPN to organization's network.
I have scripts to create logins for the users. What else do I need to do to enable remote login to the database instance xyz?