Oracle linux 6.x Re-configure x server

September 21, 2013

 

as root

X –configure xorg.conf.new

X will start,  however with a blank screen (or this was our experience)

Reset the terminal, logon as root from shell prompt

cd /etc/X11

rename or move the xorg.conf, we chose to move

mv xorg.conf xorg.conf.backup

startx

If you are not truly unlucky, your X terminal should startup

regards,

admin

Advertisements

Install Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 (64Bit) on Windows 8 Professional 64Bit

December 10, 2012

 

Environment

  1. Windows 8 Professional – 64Bit (i5 Processor, 8GB memory)
  2. Database 11g Enterprise Edition Release 11.2.0.1.0 (64Bit)

Important

Once you finished downloading the installation source from Oracle, extract the files using any available unzip utility.

Copy all the folders from “win64_11gR2_database_2of2\database\stage\Components” to

“win64_11gR2_database_1of2\database\stage\Components” folder to avoid warnings about missing components during installation. Oracle should fix it, right?

If your computer is a domain member, then

    1. Create a local user
    2. Add the user to “Administrator” group
    3. Logon as local user
    4. If you are installing Oracle on D:\ , right click and assign full rights to your account on that particular drive. Only applicable with Window7 and Windows 8

Start the installation, and you will be provided a warning. Refer the image below

warning1

Ignore it

Proceed with the installation

Ignore the update related warning also

warning2

Just follow the prompts and complete the installation. It should be a smooth sailing.

Prior trying to access the database, make sure you changed the sqlnet.ora file following

# sqlnet.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install “Software Only”, this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

We will post more screen shots soon. Stay tuned!

regards,

admin


Windows 7 64bit, Classic ASP, Visual Studio connection to Oracle Database

October 23, 2012

References

26.12.2013 Update

We realized, over a 64bit OS you may need to change the default application pool to accommodate 32bit applications. Please refer to this post

https://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx

 

 

http://www.connectionstrings.com/

http://stackoverflow.com/questions/234657/binding-asp-net-gridview-to-an-oracle-sys-refcursor

So, you are still using classic ASP or develop 32bit .NET applications using Visual Studio and Oracle databases on a Windows 7 64bit box and completely lost as connection cannot be established?

Here are few workaround solutions

Install the latest Oracle clients (both 64bit and 32bit)

If you installed Oracle client in the following folders (example)

D:\app\yourusername\product

right click on the folder, under security tab check whether authenticated users have read privileges.

If not, provide the basic privileges (Read & Execute, list folder contents, Read) Refer the image

image

Now add the user “IIS_ISURS” user and provide the same rights mentioned above

RESTART your Windows 7 “64bit” box now!

You can establish the connection from classic ASP like following

<%
    Dim adoCon                'Holds Connection
    Dim rsViewRecords        'Holds Recordset

    Set adoCon = Server.CreateObject("ADODB.Connection")
    if Err.Number <> 0 then 
        Response.Clear() 
        response.Write "<hr>ORASESSION Error<br>" & err.number & "  --  " & err.Description & "<hr>"
        response.End
    end if 

    adoCon.Open "provider=oraoledb.oracle;data source=test;user id=apps;password=apps;plsqlrset=true"

    Set rsViewRecords = Server.CreateObject("ADODB.Recordset")

    %>

 

Regards,

Admin