Skip to main content

install oracle 10g on ubuntu 8.10

installation

here is the ultimate guide, follow the same steps for 10g.

http://www.pythian.com/blogs/1355/installing-oracle-11gr1-on-ubuntu-810-intrepid-ibex

env

the $ORACLE_HOME and other env variables can be set by creating a shell under /etc/profile.d/, also remember to set $ORACLE_SID.

more /etc/profile.d/oracledb.sh
#!/bin/bash

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/oraibex
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=intrepid

dbconsole

to access the web console, login http://localhost:1158/em/ as system and password specified during db creation. the console is managed by

emctl start dbconsole

sqlplus

to connect with sqlplus remotely, first use netmgr on server side to configure.

:/u01/app/oracle/product/10.2.0/oraibex/network/admin$ cat listener.ora tnsnames.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/oraibex/network/admin/listener.ora
# Generated by Oracle configuration tools.

INTREPID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx-desktop)(PORT = 1521))
)

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/oraibex/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INTREPID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx-desktop)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = intrepid)
)
)

use lsnrctl to start/stop/check listener.
use /etc/init.d/oracledb to start/stop/check oracle.

sqlplus hr/password@//xxx-desktop:port/intrepid or sqlplus hr/password@intrepid

for more info, please refer to http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm

Comments

Post a Comment

Popular posts from this blog

spring 2.0 bean scope

singleton Scopes the bean definition to a single instance per Spring container (default). prototype Allows a bean to be instantiated any number of times (once per use). request Scopes a bean definition to an HTTP request. Only valid when used with a web capable Spring context (such as with Spring MVC). session Scopes a bean definition to an HTTP session. Only valid when used with a webcapableSpring context (such as with Spring MVC). global-session Scopes a bean definition to a global HTTP session. Only valid when used in a portlet context.
Post a Comment
Read more

Crocs sandals

Suddenly one special looking sandals get popular. The brand is Crocs. It even opens a brand store at Marina Square. The design idea is from Dutch wooden shoes, I guess. A pair of Crocs sandals is sold at around SGD 50. The price is justified for what it is made of - Croslite. Based on Crocs website, "Croslite™, a proprietary Closed Cell Resin (PCCR) which is NOT plastic NOR rubber. Croslite™ is closed-cell in nature and anti-microbial, which virtually eliminates odor. it is an extraordinary impact absorbing resin material developed for maximum cushioning. its closed cell properties resist odor, inhibits bacterial and fungal growth and are non toxic. this versatile material can be worn next to skin and be cleaned with just soap and water." However, it really looks like made of plastic or rubber, and the design is unique. Replica comes. they are sold at SGD 20, SGD 10, SGD 5 depending on quality.
Post a Comment
Read more

Singapore Girl Sex Clip Posted Online

A couple days ago, a sex video clip about a female Chinese graduate student Wang Ting Ting (王婷婷) was posted on the internet. Just as it is about to cool down, another sex video clip pops. It is a sex clip of a Singapore Nanyang Polytechnic student . The video clip was stored on her cell phone. Someone stole it and posted the video clip on the Internet. This is a breaking news. It is even reported on major Singapore and Malaysia newspapers. Now we have so many cool gadgets. It is a breeze to shoot photos/videos, and share them on the internet. Everyone, even dog, is on the internet waiting for breaking news. Be careful when you do something secret or stupid. It may appear all over the world, live!
Post a Comment
Read more

No smoking sign

Watch out this sign before you light the cigarette up. SGD 1000 fine! However, I wonder if someone had really paid so much for violation.
Post a Comment
Read more

Prostitutes in Singapore

Singapore is very realistic about this issue. Prostitution is legal. The famous red light zone is Geylang area. I heard Hong Kong officials are considering to legalize this business in HK also. Singaporeans are not allow to work as prostitute. Maybe also SPR. The prostitutes are mainly foreign workers from poor countries in SEA area, such as Indonesia, Thailand, India, Malaysia, not from China. They come under special 2-year working pass, and must pass the health exam, yes, to prevent STD such as HIV, AIDS and so on. The brothels are mixed with normal resident houses. The brothel's house number is red lighted. The price is ranged from SGD 50 to SGD 200. Illegal sex workers are also around, and in some massage clinics. A very recent fatal case and newly effective government policy make a special social group - Chinese accompanying mom for studying kids a hot media buzz again.
Post a Comment
Read more