I've been beating my head against the wall trying to reset the password for an Oracle 8.1.5 database. I've tried the following and this seems to be the consensus on how it should be done.
You have to go to server machine and logon as OS user
that has installed Oracle (it belongs to DBA group or something like this).
After that you can
svrmgrl>connect internal as sysdba
Now try to change the SYS password:
svrmgrl>alter user sys identified by manager;
If this runs successful you will be able to logon
svrmgrl>connect sys/manager as sysdba
However I still get prompted for a password! I'm logged in with an account that is a domain admin and a member of the ORA_DBA group.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…