Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help for a total Neophyte
Message
From
01/03/2001 09:13:31
 
General information
Forum:
Oracle
Category:
Troubleshooting
Miscellaneous
Thread ID:
00479348
Message ID:
00480937
Views:
22
Great Mark - thank you. I appreciate your patience with my newness to this!

>I have never used the Navigator. I always use VFP or SQL*Plus. Try the user names SYS or SYSTEM. The default password for 1 of those is MANAGER. Do this via SQL*Plus. In SQL*Plus, you can do an ALTER USER SOMEUSER IDENTIFIED BY MYPASSWORD; [end the command with a semi-colon and hit ENTER]
>
>You can also CREATE USER SOMEUSER IDENTIFIED BY MYPASSWORD;
>
>You should GRANT DBA TO MYUSERID;
>
>The DBA privilege has total access to the database and allows you to do anything.
>
>You may be able to do all this in the navigator.
>
>>I'm starting from ground zero - any help would be greatly appreciated...
>>
>>I've downloaded and installed PO 8i. When I open Oracle Navigator, I have a connection to their sample data.
>>
>>I used the Database Configuration Assistant to create a new database. I chose to copy the existing database files. Then came the screen to choose the global database name and the SID. I entered TEST as the global database name, and it automatically created "TEST" in the SID. Then I hit finish, and it created a database. I'm having a few problems at this rudimentary step:
>>
>>1) It is using a naming convention based on my internet domain. Specifically, it has called the database "test.mediaone.net" (Mediaone is my cable ISP). I'm not sure why it did this or what this means, or how to get around it.
>>
>>2) After doing this, I cannot establish a connection to the database in the navigator. I type in the user names and passwords it provided me at setup, but it won't establish a connection.
>>
>>I realize this is rudimentary stuff. I've order some books, which I'm not sure even get this basic. I'd appreciate any assistance or even direction on what to read to solve these problems. I've tried the Oracle documentation, but I'm finding it circuitous - not geared towards someone at such a basic level.
>>
>>Thanks in advance,
>>
>>David
Previous
Reply
Map
View

Click here to load this message in the networking platform