Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 27th, 2004, 06:59 AM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 ALTER USER sys IDENTIFIED by syspass, 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

 
Old July 5th, 2004, 06:06 AM
Registered User
 
Join Date: Mar 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Pankaj,

With what user you ran the ALTER USER command

Rgds
TheLion
 
Old July 12th, 2004, 09:33 PM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is probably a very normal situation.

In your sqlnet.ora file, if SQLNET.AUTHENTICATION_SERVICES is set to NTS, Oracle is allowed to use NT's authentication facilities rather than passwords to authenticate users. If your Windows user is a member of the ORA_DBA group, and you are connecting on the same machine that the database is running on, you can log in as sys without a password.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC





Similar Threads
Thread Thread Starter Forum Replies Last Post
weird problem with Ch 9 example proslambano BOOK: Ivor Horton's Beginning Visual C++ 2005 1 February 2nd, 2007 02:06 AM
weird ASP/VB/Oracle problem.... Bij81 Classic ASP Databases 0 October 28th, 2005 03:57 AM
weird problem! Please Help johnjohn Classic ASP Databases 5 December 21st, 2004 10:27 AM
Weird Access Problem MattyJ Access 2 October 1st, 2004 02:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.