Connecting to Oracle 9i personal edi from another computer on Network
Hi all,
I have WinXP home with Oracle 9i 9.2.0.1.0 personal edition installed on my Dell notebook. I want to develop my dba skills and I am thinking of connecting to this database on my notebook from another pc which has WinXP pro by installing only the oracle client(can i install other software to connect) on this system. By the way these two systems are in a network through a router(used to connect to internet). Your advises are welcome. Also what kind of tasks to you recommend to develop skills as a DBA. I want to start as a Jr DBA. Plz recommend some tasks.
Thanks in advance.
Re: Connecting to Oracle 9i personal edi from another computer on Network
Quote:
Originally posted by ajashadi
Hi all,
I have WinXP home with Oracle 9i 9.2.0.1.0 personal edition installed on my Dell notebook. I want to develop my dba skills and I am thinking of connecting to this database on my notebook from another pc which has WinXP pro by installing only the oracle client(can i install other software to connect) on this system. By the way these two systems are in a network through a router(used to connect to internet). Your advises are welcome. Also what kind of tasks to you recommend to develop skills as a DBA. I want to start as a Jr DBA. Plz recommend some tasks.
Thanks in advance.
You will need to know how to configure the listener, which you can do with Personal Oracle. See if you can find a simple application on the net somewhere and create a database for it. You can always use Access as a quick and dirty front end. Read the book "SQL Queries for Mere Mortals". You really want to focus on learning database concepts though.