Removing an Oracle Database from Windows

If you removed a database  but it's services are still showing up at services.mcsi then;
suppose the database name is demodb

oradim -delete -sid demodb

deletes the services, etc. related to this database.

oradim is an oracle utility for windows only!

Database Creation Assistant Fails during 2% complete with ora-12560

I was installing Oracle 10g to a Windows 2003 server yesterday and the installation went okay. But at the confuguration phase, dbca failed to create a general purpose database at %2 complete with  tns errors: ora-12560 and ora-12514.


So I cancelled the installation and head through metalink. After a few searches I first tried to remove / comment


SQLNET.AUTHENTICATION_SERVICES= (NTS)

row from sqlnet.ora file. (Note 164930.1)Then tried the dbca again; but no luck.

Then I found another note(Note 747243.1) stating that some policies could prevent the creation of oradba user and ora_dba group on windows. So the note suggested that I should manually create them and give it a try again. That was exciting  because I found out that there was a ORA_DBA group but no ORADBA user. So I immediately created a ORADBA user and add it to administrators group on the server. But unfortunately, this did not change anything, the error was still showing up at the exact same stage..

I hit google search and find that forum post, thankfully..

http://forums.oracle.com/forums/thread.jspa?threadID=317706 (merope is me at that page :))

Finally, changing the Regional settings of the server solved the problem.  To change it, navigate to control panel, regional settings and change the language to US English in the regional options tab.. 

Enable Archive Logging in Oracle 10g

Unlike 9i, log_archive_start does not have a meaning in oracle 10g. You should do the following to enable the archive logs:

Open sql*plus

shutdown immediate

startup mount

alter database archivelog

alter database open

It can be seen on the screen below, sorry that its local language, Turkish but you can still  follow it, though

how to create a new temporary tablespace

First create a new temp tablespace. Yes, unlike the undo tablaspace, you can have more than one temp tablespace -but only one of them could be database default temporary tablespace at once.

CREATE TEMPORARY TABLESPACE TEMP4 TEMPFILE '/oracleAS/TPRS/oradata/TPRS/temp4.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

 

now change the database default tablespace 

alter database default temporary tablespace TEMP4;

 

get rid of the  the old one!

drop tablespace TEMP1 including contents 

unable to determine local host | Enterprise manager error 10g on windows

After a succesful 10g installation and a dbca assisted db creation, installer complains about "enterprise manager configuration failed ..." and you can retry manually by running emca.

and after you click ok the explorer opens up in a window  containing something like that in address bar:

http://tup03srv49.tuprasnet.local:%EM_UPLOAD_PORT%/em/

When I explore emconfig.log I saw:

Creating directories...
Setting console properties ...
Setting log and trace files locations for Console ...
Setting log and trace files locations for Agent ...
Service "OracleDBConsoleIZMTPRS" create SUCCESS
Service "OracleDBConsoleIZMTPRS" delete SUCCESS

Mar 29, 2010 8:56:15 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: '\regedit.exe' is not recognized as an internal or external command,
operable program or batch file.
Creating registry entries failed. Aborting...

 first I checked to see if the windows account which I was using is a local administrator. the account was in a group and the group was under the administrators group. I also added the account directly.

after that I executed:  emca -config dbcontrol db


 worked like a charm!

Orainventory permission problem when installing a second database on same server

You do not have sufficient permissions to access the inventory 'you directory'. Installation cannot continue. Make sure that you have read/write permissions to the inventory directory and restart the installer.

If you're getting this error while you are trying to install a new database on a server which already has another database on it, run the runinstaller with -invPtrLoc like below:

runInstaller -invPtrLoc /test/oraInst.loc

ocssd.bin process could not be killed

There is a process called ocssd.bin when running 10g on Unix, even if you have shut the db down, it continues to respawn no matter how many times you try to kill it.

here is the way to stop it :

/etc/init.d/init.cssd stop