rasti.hil@hilandco.com +41 79 367-9677

"RemoteOperationException: ERROR: wrong password for user" with Oracle 10g on Windows XP

Here is a simple solution for the following error which was given to me from the browser when I tried to startup/shutdown the db with Enterprise Manager.
Go to the Start -> Control Panel -> Administrative Tools -> Local Security Policy.
Select Local Policies -> User Right Assignment -> Logon as a Batch Job.
Click on Add User Or Group, and add the user.


janos ujvari
May 28, 2008.

Creating an Oracle Database Using the DBCA

Hi there, last time I show a brief description how to install db. Now I’ll show how to create database using Oracles tool DCBA (Database Configuration Assistant) on windows.

The Oracle Database Configuration Assistant (DBCA) is a Java-based tool used to create Oracle databases. If you’ve been a DBA for a few years, you probably remember the days of writing and maintaining scripts to create databases. Although it is still possible to manually create a database, the DBCA provides a flexible and robust environment in which you can not only create databases but also generate templates containing the definitions of the databases created. This provides you the ease of using a GUI-based interface with the flexibility of Oracle-generated XML-based templates that you can use to maintain a library of database definitions. You can also use the DBCA to add options to an existing database or to remove a database. We recommend using the DBCA facility to create your databases, even if you are a die-hard command-line DBA. You can use the DBCA to create a database when the Oracle software is installed, or you can invoke the DBCA later to manually create a database. In the following sections, we will show you the steps necessary to create an Oracle database using the DBCA tool.[1]

Start the DCBA: choose Start -> Programs -> Oracle Home -> Configuration and Migration Tools -> Database Configuration Assistant. Click next.



When you install the db it comes with a few template, which are designed for commonly use.


Click next.


Click next.


Set the Global Database Name and SID and click next.
Note that the Oracle system identification (SID) name can be maximum eight characters and must be unique on the server.


You can configure Enterprise Manager to monitor and manage database, if you had installed Oracle Management Agent DBCA will detect it, I don’t have it so everything stays on default and click next.


You must specify passwords for a system user accounts, you can choose do they have the same password or you can set it individually.


Chose the radio button next to File System, DBCA will use OFA model to create directory layout. Click next.


We are creating database from template so leave on default and click next.


Oracle Flash Recovery is new option in Oracle 10g. Oracle uses the Flash Recovery Area to store and mange the archive logs. All file necessary to recover the database following a media failure are part of the Flash Recovery Area.
Click next.
Select which schema to install. And click next.


Sample Schema provides working examples of how to configure and use certain extended features of the db.


You can set memory management, but I for practicing using the default. Now you see the summary for installation:


In the following screen you can decide do you want to create a new db or new db template


Select Create Database and click Finish


Click ok to accept confirmation.


Depending on your system and what are you installing, it may take a wile.


Click on Password Management if you want to unlock/lock some users and also change passwords.


Click ok to confirm.
Click on exit.

Books:
[1] OCA: Oracle 10g™ Administration I Study Guide, Chip Dawes, Bob Bryla, Joseph C. Johnson, Matthew Weishan; ISBN: 0-821-4367-9

janos ujvari
May 28, 2008

Sql Developer and subversion

Creating a local Subversion repository

To create a local Subversion repository, choose Versioning > Subversion > Create Repository.

In the Create Subversion Repository dialog, a location and file system type are suggested for your new repository. To provide an example to use in this guide, overtype the repository path with D:/repos. You can leave the file system type as the default Native, and you do not have to provide a connection name.

When the repository is created, a connection to it will be created automatically. You can see this in the Subversion Navigator:

Repository URL: Full, valid URL for the location of the Subversion repository. The following are URL schemas and the access methods they map to:

  • file:/// -- Direct repository access (on local disk)

  • http://-- Access via WebDAV protocol to Subversion-aware Apache server

  • https:// -- Same as http://, but with SSL encryption

  • svn:// -- Access via custom protocol to an svnserve server

  • svn+ssh:// -- Same as svn://, but through an SSH tunnel

Connection Name: Name for this connection. If you leave this box blank, the connection will be given a name based on the URL of the repository location


Subversion repository on the other computer

1)putty:

  • specify destination and port name: for example www.something.com:22
  • under Connection->SSH->Tunnels add source port number and the destination

2)SqlDeveloper:

Right click with mouse on Subversion > New Repository Connection


3) Right click with mouse on svn://localhost/repos > Check Out


Click the Yes button.


Destination folder is the local folder. For example D:\work\repos_local

Click OK


4) basic svn commands

· checkout. “download” files from repository

· update: if someone else had changed the repository, update your local files

· add, delete, copy, move: you can add, delete, copy, move files/directories

· commit: maybe this command is the most important, it “put up” your changes to server.

Install Oracle Database 10g 10.1.0.2.0 on Windows

Trough my preparation for OCA 1Z0-042 exam, it is essential to install and manage database, so I decided to create a blog about it.

First keep in mind that 10g requires at least 512MB of RAM 1.5 + 1GB of disc space. Before you start the installation you need to review the installation guide.

Download the installation source from Oracle web page (www.oracle.com).When download is complete unpack it (10g_win32_db.zip) and change your working directory to: 10g_win32_db\Disk1, by double clicking on setup.exe file you will start the Oracle Universal Installer.

Oracle provides a simplified installation protocol, by leaving the Basic Installation button checked you will use that, but I’ll use the advanced so click on radio button next to Advanced Installation and click on next button.

In a following screen you can set file locations, but if you are not familiar with OFA (Optimal Flexible Architecture by Cary Millsap) model than you should only change the installation name and click next,

Now you can decide which kind of installation you want to do, because I’m learning from book in which the enterprise edition is preferred, click on radio button next to Enterprise Edition and click next.

Later I’ll show you how to create a database with other Oracle tool (DBCA Database Configuration Assistant), so now select the Do not create a starter database radio button, and click on next button.

A product Summary appears, by clicking on Install button the Oracle Universal Installer will begin the actual installation. Keep eye on window so you can see what’s happening during installation.

When the installation is complete you get another summary

The summary is about that were the following things available:
  • Ultra Search (http://hilandco02:5620/ultraserch)
  • Ultra Search Administration Tool (http://hilandco02:5620/ultraserch/admin)
  • iSQL*Plus (http://hilandco02:5560/isqlplus)
Note 1: hilandco02 represents my machine, on your it will be different.
Note 2: because there is only the infrastructure but not any db is installed these link will only work when you create a db. Click on exit and confirm that you really want to exit.

janos ujvari
May 23, 2008