Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Extreme beginner questions
> I come from a SQL Server world, so again, please excuse my extreme
> newbiness - -
Thanks for letting us know. You will find a lot of differences, starting with "a SQL Server Database is roughly equivalent to an Oracle Schema"
> 1. What is the default username for Oracle?
There is NO default username. The data dictionary (master DB) is owned by user SYS, which you should never need to access. The primary DBA userid is SYSTEM, which you would use to create your DBA and the users.
> 2. Is the Oracle Admin Assistant akin to the Enterprise manager in SQL
> Server?
Never used Enterprise Manager in SS, so I couldn't answer that. However, Oracle's management console is called 'Oracle Enterprise Manager' and that might be what you want.
You need to expand a few things: what version of Oracle, and what version of Windows XP. If you have XP Home you can expect the unexpected - things just don't work quite right. This is especially true for a fresh install of XP Home, as compared to an upgrade.
> 3. I try to connect in OAA - and it asks me for a Net Service Name - - where
> do I find that?
Check the Services to see whether you have someling listed like 'OraListenerxxxx' - the xxxx is your net service name, and probably matches the Instance name.
I STRONGLY encourage you to
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** Top posting guarantees I will not respond further ***Received on Sat Oct 29 2005 - 19:15:21 CDT