weird Oracle problem
-
Hi everyone, I am having a weird Oracle problem. I used the command line tool dbca (database configuration Assistant) to create an Oracle database like so: dbca dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbname TESTDB -sid TESTDB The database was successfully created. It said that the initial sys password was change_on_install. The problem is that I could log onto as sys using any password and even when I did [i]ALTER USER sys IDENTIFIED by syspass[/i], it did not change the password. It says that the user has been altered but I can still logon as sys with any password. Am I missing something? Please help! Thanks, Pankaj Without struggle, there is no progress
-
Hi everyone, I am having a weird Oracle problem. I used the command line tool dbca (database configuration Assistant) to create an Oracle database like so: dbca dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbname TESTDB -sid TESTDB The database was successfully created. It said that the initial sys password was change_on_install. The problem is that I could log onto as sys using any password and even when I did [i]ALTER USER sys IDENTIFIED by syspass[/i], it did not change the password. It says that the user has been altered but I can still logon as sys with any password. Am I missing something? Please help! Thanks, Pankaj Without struggle, there is no progress
I take it that you installed the Oracle Server on the same PC that you program on? If you connect from another computer (you'll have to install the Oracle Client), it should prompt you for a password. Remove the "NTS" from the SQLNET.AUTHENTICATION_SERVICES list in your sqlnet.ora file. If that's the only entry, you can put a pound sign (#) in front of the line. That will disable the integrated NT authentication, and require you to use a password. Don't forget to also change your SYSTEM user's password; the default password for SYSTEM is "manager". Incidentally, it'd make a world of difference for speed if you kept the Oracle server on a different computer then the one you develop with. You could even push Oracle onto an older, slower computer- as long as you meet the minimum system requirements for the Oracle Server, you'll be OK. -Thomas