Install SQL Developer on Open Suse

This post will be very useful for whom is new in Linux and is trying to install SQL Developer.

1. Donwload SQL Developer installation from Oracle SQL Developer RPM for Linux.

2. Install that rpm package:

> su
Password:

# rpm -Uhv sqldeveloper-3.0.04.34-1.noarch.rpm

3. Download JDK from here.

Go to the directory, where you have downloaded JDK:

> su
Password:

Make it executable:

#chmod a+x jdk-6u25-linux-i586-rpm.bin

Run that file:

# ./jdk-6u25-linux-i586-rpm.bin

4. Add/change the following environment variables:

JAVA_HOME=$JAVA_HOME:/usr/java/jdk1.6.0_25/
PATH=$PATH:/opt/sqldeveloper/

Note: That variables should be added/edited in .profile, if you don’t want to set them every time you log on.

5. Run SQL Developer:

# sqldeveloper

If you have some problems with running it, simply exit from the terminal and reconnect it and try above steps again. Or check environment variables if they are correctly set. This may help.

 

 

 

Open Suse 11.4 Wireless is connected(active) but there is no internet [SOLVED]

In this post, I am going to provide you by one of the solution which helped me…

I simply renamed resolv.conf file which is located in /etc:

:~> su
Password:

# cd /etc
# mv resolv.conf resolv111.conf

That’s it.

Let’s expalin a little bit more:

What is resolv.conf?

Resolv.conf is a resolver configuration file. This file defines which Doman Name Servers to use.

See the content of this file:

#cat resolv.conf

search domain.com site
nameserver 192.168.1.111
nameserver 192.168.1.143

Means-> when you type http://www.google.com It will go to the first DNS server 192.168.1.111 and ask what IP does this google.com corresponds. If this nameserver doesn’t know the answer, 192.168.1.143 will be next nameserver to be asked.

 

If you know the correct name servers just modify this file with correct entries(instead of renaming it).

But if it doesn’t work… Run the Network Settings, in Global Options tab, in the  IPv6 Protocol Settings section, uncheck the box Enable IPv6.

 

Install Oracle 10g on Open Suse 11.4

1. Download Oracle Databse 10g software from oracle site, from here.

2. Make sure that you have the following packages installed:

# rpm -q gcc gcc-c++ glibc libaio libaio-devel make openmotif openmotif-libs

My output:

gcc-4.5-19.1.i586
gcc-c++-4.5-19.1.i586
glibc-2.11.3-12.15.1.i686
libaio-0.3.107-7.1.i586
libaio-devel-0.3.107-7.1.i586
make-3.82-140.1.i586
openmotif-2.3.2-5.1.i586
openmotif-libs-2.3.2-5.1.i586

If any of them is not installed  run the following command for each of the uninstalled package. For example:
# zypper install gcc
And install the following package:
# zypper install libstdc++33
3.Create necessary groups, user and change the password for the newly created user:
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle
4. If the oracle user’s home directory doesn’t exist, create it:
# mkdir /home/oracle
# chown -R oracle:dba /home/oracle
5. Let’s create the directory, where Oracle software should be installed:
# mkdir -p /u01/app/oracle/product/10.2.0/db_1
# chown -R oracle:oinstall /u01
6. Setting ORACLE_BASE, ORACLE_HOME environement variables:
# vi /etc/profile.d/oracle.sh
——————————————And add the following entries
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
And also:
# vi /etc/sysconfig/oracle
——————————————And add the following entries
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
Note that the default value for ORACLE_BASE is /opt/oracle
7. Connect as an oracle user and unzip downloaded file:
# su – oracle
oracle@mariamsuse:~> unzip 10201_database_linux32.zip
If you have already unzipped this file by another user just change the permissions, like:
# chown oracle:oinstall 10201_database_linux32.zip
and then extract.
8. Edit the file database/install/oraparam.ini 
[Certified Versions]
Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2,SuSE-11

 

Note: At the end I have added SuSE-11

9. Go to the folder ……database/ and run:
# su – oracle
Password: 
           
oracle@mariamsuse:~> ./runInstaller
If something doesn’t work… exit from the existing terminal(command line) and reconnect.
Oracle Universal Installer should be started…
“During installation, there are 1 warning and 4 Waiting for verification. Just check all of them and proceed to installation.”

Open Suse desktop turns black problem [SOLVED]

I don’t know how, but I have had enabled desktop effects on my Open Suse, which caused computer screen to turn black when computer was not in use during some minutes.I couldn’t see my mouse pointer, it did not have any reaction on pressing keys. Just CTRL+ALT+F1(turning to console mode) worked.

I have found a good solution and I want to share it with you.

Assume that you see a black screen now.

Go to the console mode:

CTRL+ALT+F1

Go to the following location:

cd .kde4/share/config

Edit the following file:

vi kwinrc

Find the following entry:

[Compositing]

Enabled=true

Change value true to false, the output should look like this:

[Compositing]

Enabled=false

Note: If you do not know how to edit file from command line do the following: press “i” key, which makes file writable in a console, now you can move to your desired line by arrow keys and change the value, after that press “Esc” key and type the following: “:wq” which means save the changes and quite.

Switch back to graphical mode:

CTRL+ALT+F7

Restart X-Graphics Server:

CTRL+ALT+BACKSPACE (twice, fast)

Now you should see the login screen.

 

 

How to change MAC address in Open Suse

Connect as a root user:

> su
Password:

Go to the following location:

> cd /etc/init.d

and edit the following file by some editor, I prefer to use vi editor.

> vi boot.local

Press “i” key, which means enabling insert mode, and then add the following entries:

/sbin/ifconfig eth0 down
/sbin/ifconfig eth0 hw ether 7F:G2:A4:30:R1:H7
/sbin/ifconfig eth0 up

7F:G2:A4:30:R1:H7 is the MAC address, enter yours.

after that click ESC key and type:

:wq

which means write and quite.

Now reboot the system :

>reboot

That it, I hope this post will help someone 🙂

 

 

 

 

Installing Google Chrome in Open Suse

I couldn’t install Google Chrome browser by single-click. I found it a little bit difficult to install that browser on Open Suse, that is why I am writing this post.

I hope my post will be useful for most of the people . Smile

First of all LSB (Linux Standard Base Core) package should be installed.

The goal of the LSB is to develop and promote a set of open standards that will increase compatibility among Linux distributions and enable software applications to run on any compliant system even in binary form. In addition, the LSB will help coordinate efforts to recruit software vendors to port and write products for Linux Operating System.

Connect as a root user:

mariam@linux-jg40:~/Downloads> su
Password:

Install that package

linux-jg40:/home/mariam/Downloads# yast2 -i lsb

Download Google Chrome installation package for Open Suse from here.

Choose appropriate radio button: 32bit or 64bit.
Accept the license terms.

After that install Google Chrome.

linux-jg40:/home/mariam/Downloads# yast2 -i google-chrome-stable_current_i386.rpm

Note:

i386 indicates that this package is for 32bit OS
x86_64 —-is for 64bit

If after that Chrome is installed but doesn’t start up then run the following:

linux-jg40:/home/mariam/Downloads# zypper in libpng12-0

You can show the shortcut on the desktop by the following way:

Right click on the Desktop Folder-> choose Create New-> Link to Application.

Go to the Application tab and fill the following textboxes.

Note: In Command field there is written /opt/google/chrome/google-chrome.

Properties for Program.desktop

Click OK.

To change icon for the shortcut : Go to the General tab and click squared box, choose Other icons and clickbrowse, choose icon and click OK.

Happy browsing!