Login Problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Login Problems

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Question

    I have a couple of problems with my copy of 8.1.7.0.0

    I have a bunch of questions, and appreciate any help or advice.


    1) I can login to the SQL*PLUS and attach to the DB, but I
    am having problems with the DBA STUDIO locking up. It sez JREW.EXE not responding when I shut down my system.

    2) I have installed the DB, created a DB, but haven't set the parameters in the .ORA file. Is this a problem? Also, I have two other DB instances that the install picked up from some prior install. I went into the ADMIN for WIN console and found the service on for these DB's, but I can't seem to delete them. Any help or suggestions appreciated.

    3) I have logged in as internal/oracle as sysdba, but I don't show up as a user. Am I still setting things up? Because when I open the DB it shows my settings, but I can't open tables or view schema. Have I finishe the create table\tablespace?

    TIA...DBA_Toad


  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    From your questions I understand you have installed the software/created the database multiple times adn messed up with installation files. Whenever you hit install problems/db creation problems its wise to clean it per oracle recommendations and then reinstall. Preferably using Oracle Universal Installer you have to deinstall the software OR use db configuration assistant to remove the database.

    1) Might be installtion files are messed up. try shut down box and reboot and see that helps.

    2) Your SIDs are registered in the Windows entry as services, you might need to delte the entries or stop those services and change them to manual start onstead of auto start with machine reboot.

    3)You are connected as SYS. What do you meant by you can't show up as user ? If you create a table it show up there is table you created. But, its not advised to create a table as SYS user.

    Follow the documentation and do the tasks as docs suggest.
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width