Re: Need help creating a database

I found the problem. Despite being embarrassed to admit what I found, I figure everyone deserves an explanation.

A script supplied by a software vendor, that was supposed to create a new database for his application, overwrote the sqlnet.ora file. This is what it put in it:

SQLNET.AUTHENTICATION_SERVICES = (NTS) I'd like to supply answers to the questions I figure you likely would ask:

Yes, the server is Unix (Solaris)
Yes, the script was supposed to be for Unix (it was named build_files_unix.pl)
Yes, I'm the idiot that ran it (I wasn't too concerned about it scrweing up a new database, it didn't occur to me that it could cause "server level" problems)
Yes, it took me nearly 3 days to find the problem (until I found the cause, I didn't make the connection betweent the vendor supplied script and the authentication problem)

To everyone that offered help, please accept my sincere thanks. The solution ended up being pretty simple, but the problem caused me some severe grief.

Randy Harris Received on Thu Nov 10 2005 - 18:48:21 CST