10g (1) 11c (1) 11g (5) 12c (4) 3.0 (1) ApEx (4) Cloud (11) database (10) DBA (1) EBR (1) EC2 (2) education (3) ExaData (1) F2F (1) Forms (7) java (1) language (2) memorabilia (2) Metalink vs MOS (4) multi-cultural (3) on-line communities (1) oracle (7) performance (5) projects (1) reciproke (1) Reports (2) RUP (1) sales (2) services (5) silence (1) SOA (3) SQL Server (1) standards (6) Sun (1) support (6) W8 (1) WebLogic Server (5)

Wednesday, October 28, 2015

Setting up SQL Server 2012 vs Oracle some version

Setting up a SQL Server 2012 for various reasons. What are the differences vs a set up of a database, that are to be reached from remote. Well...there are some...There is a difference in terminology. And annoying default - but they are surely there for a reason - settings.

 A very good thing is that there is no TNSNAMES.ORA...:-). The Windows authorization mechanism handles all of that. So when everything is in place the remote PC finds everything very smoothly, thru the network.

Every change of the settings are done in various parts of the  SQL Server 2012 Manager-tool.

In SQL Server there is a concept of "USER" and (?) a "LOGIN". couple the USER to a specific LOGIN.

CREATE USER myuser FOR LOGIN myuser;

You have to Enable TCP/IP protocol.

The annoying - imho - is the default setting that disables access from outside. So just find the Enable SQL Server & Windows Authorization.

From zero to an accessible database the time should not be more than 8-12 hours for a regular database knowledgeable person. But bare in mind that that is a straight forward installation.

Friday, April 24, 2015

Ran into trouble immediately...

Trying to install Oracle 12c database on a laptop. Now, the laptop is a laptop that is handled by a service organization. I have no authorization to create a user on that laptop...

So...the creation of the Windows user for the Oracle_Home-processes failed.

Will try again and use the Built-in Windows user.

What is there to do?

Monday, January 27, 2014

This is a text from Sten Vesterli

It is very good in its description of the process of an IT-person in the organisation. Thank you Sten!

New employees start as non-contributors. They have low business knowledge and even though they might know the technology used in the organization, they do not know the existing systems or how it is specifically used.

As the employee masters the existing systems and technology, they move into the role of geek. These are the people with high technical skills, but low business understanding. Unfortunately, many IT people stay at this point on the IT value path, which is where they are vulnerable to outsourcing.

Some people move on to a role as analyst with a more business-oriented role. They start to understand the business, but the amount of learning necessary often means that their technical skills regresses.

A very few people move on from the analyst role toward being a star employee. Once they have mastered the business, they pick up the technology again, but now with a much better understanding of how technology can be used for strategic advantages fro the organization.

The valuable stars have both technical skills and business knowledge, but the path to IT stardom doesn't have to lead through years in the geek role. New non-contributors should be encouraged to take the value shortcut and learn the business first before building up their technical skills

Saturday, January 18, 2014

Container databases is The Future - or not?

Well probably not since there is no flashback.  What is a container database? Well there is lots to read on the internet. Of course. But it is - as I see it - the base for Clouds, private, public or hybrid.

Friday, January 10, 2014

The cloud is for sale!

In Europe as well in other parts of the globe there are movements rolling where you can buy and sell Cloud Computing resources. Interesting development.

There is a site already out there. Sharing prices at site is closed, I just discovered...2014-01-13...

But there are other sites, this is the Börse in Europe for the Cloud. So capacity is for sale. App-servers, database servers, what have you. Go buy, or sell your capacity.

What are the implications of this "stock" exchange. Well time will tell. But it is kinda strange. Or it is not...there could be companies that will gain capital from computer storage, or computer application server resources during, let's say the Olympics in the year 2016. Or when a company suddenly and in a minute time gets lots of DoS-attacks. Or even not attacks. But a immense grow on traffic.

Then, who do you gonna call? Cloud-sellers...

Wednesday, October 23, 2013

Moving from Forms 10g to 11g

Remember that there is a new version PL/SQL engine taking care of calls to the database. I stumbled upon a strange error moving from 10g to 11g.

Now in 11g, the PL/SQL is more restricted in functions behaviour.

A function MUST return av value. So code that looked like this, roughly, in Forms 10g passed, but should not have passed. When run in a 11g environment there are strange behaviour of this new more robust view of a function. Some of these errors can be hard to find, but a &debug and/or

MESSAGE('Informative text');

does the trick.

Here is what passed earlier, but no longer during run-time. It compiles, but is giving strange errors in Forms 11g. Note that the solution is just to RETURN something in the THEN-clause.

  l_MyVariable VARCHAR2(80);

 IF some_expression 
   /* Do something */


Thursday, September 26, 2013

To ExaData or not to ExaData

that is the question. Several years ago ExaData platform came along. When should you go for that platform?

I do not really the beginning of the ExaData product release it was stated that it was aimed at Business Intelligence [BI] applications and not OnLine Transaction Processing [OLTP] applications. Now when Cloud computing is more and more not just a buzz word but a reality things might have changed. They have changed, the new applicances are aimed at OLTP. Which is a natural step in the ExaData product line.

However...there are troubles for the non database guys...

There are of course implications on applications. Some tips over here. But there could be more. And then Tom Kyte is not addressing the DataBase Administrators [DBA] but the developers of the applications. The transition - yes transition not migration :-) - to ExaData from a traditional Oracle DataBase solution have implications on the application.

That is not necessarliy the primary focus for the DBAs, they see the advantages from their point of view in disk space mangagement and such things that DBAs should and are caring for.