hello,
i am brand new to oracle, (but not to sql databases) so naturally, i'm having problems. <smile>
i installed oracle xe database and sql developer.
i created a connection to the database. the test and connection button worked
i then tried to create a new user and get the error ora-65096 invalid common user or role name.
the username that i entered is tracyw.
i tried to find a help page that explained how to fix the problem and what the problem is, but i could not find one. the 'cause' and 'action on the error dialog box did not provide a solution that i understand.
is there a 'basic' user guide that i could download to become familiar with how to set up user accounts, connections, assign rights, etc?
now, when i open sql developer and try to connect, i get this error
listener refused the connection with the following error: ora-12505.
again i searched, but could not find a resolution for the problem.
i didn't get any errors during the installation, so i don't know what's going on.
any help would be greatly appreciated
thank you