이수안 데이터 연구실

검색 :
RSS 구독 : 글 / 댓글 / 트랙백 / 글+트랙백

글 검색 결과

이수안 데이터 연구실
글 8개

?ㅻ

이수안 데이터 연구실
Database/Oracle
2008/06/17 10:56, 글쓴이

[##_1C|1065187050.jpg|width="600" height="420" alt="?ъ
이올린에 북마크하기(0) 이올린에 추천하기(0)
"Oracle" 카테고리의 다른 글
2008/06/17 10:56 2008/06/17 10:56

맨 위로

피드백 : 트랙백 없음 | 댓글 1개

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

Installing Oracle Database 11g on Linux

이수안 데이터 연구실
Database/Oracle
2008/05/21 16:48, 글쓴이
OTN Logo

Installing Oracle Database 11g on Linux

Purpose

In this tutorial, you learn how to install Oracle Database 11g on Linux.

Topics

This tutorial covers the following topics:

Overview
Installing Oracle Database 11g on Linux
Testing Your Installation
Summary

Installing Oracle Database 11g on Linux

To install the Oracle software, you must use the Oracle Universal installer.

1.

For this installation, you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, open a terminal window and enter the following:

./runInstaller.sh


2.

The product you want to install is Oracle Database 11g. Make sure the product is selected and click Next.


2.

You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle for Database Password and Confirm Password. Then, click Next.


3.

You need to specify your Inventory directory. The location should be set to /u01/app/oracle/oraInventory. Accept the default Operating System group name, oinstall. Then, click Next.
4.

The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors before continuing. When the check successfully completes, click Next.
5.

Oracle Configuration Manager allows you to associate your configuration information with your Metalink account. You can choose to enable it on this window. Then, click Next.
5.

Review the Summary window to verify what is to be installed. Then, click Install.
6.

The progress window appears.
7.

The Configuration Assistants window appears.
8.

Your database is now being created.
9.

When the database has been created, you can unlock the users you want to use. Click OK.


10.

You need to execute orainstRoot.sh and root.sh as the root user.


11.

Open a terminal window and enter the following commands. Follow the prompts as instructed. 

su -
<rootpassword>
cd /u01/app/oracle/oraInventory
./orainstRoot.sh
cd ../product/11.1.0/db_1
./root.sh
exit
exit
12.

Switch back to the Universal Installer and click OK.


13.

Click Exit. Click Yes to confirm exit.

Testing Your Installation

To test that your installation completed successfully, perform the following steps:

1.

Open a browser and enter the following URL:

https://<hostname>:1158/em

where <hostname> should be changed to your machine name, IP address, or localhost.

Because Enterprise Manager Database Control is a secure site, you need a certificate. Select the Accept this certificate permanently option, and then click OK.

2.

Enter system as the User Name and oracle as the Password, and then click Login.

3.

The Database Control Home Page appears. Your installation was successful.

Summary

In this tutorial, you learned how to install and test the Oracle Database 11g installation on Linux.


이올린에 북마크하기(0) 이올린에 추천하기(0)
"Oracle" 카테고리의 다른 글
2008/05/21 16:48 2008/05/21 16:48

맨 위로

피드백 : 트랙백 없음 | 댓글 1개

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

Oracle Ports for Network Services

이수안 데이터 연구실
Database/Oracle
2008/05/19 14:46, 글쓴이
  • An asterisk * in the Notes field indicates that the ports are IANA registered.
Service TCP UDP Notes
sql*net 66 66 * Oracle SQL*NET. I think this is legacy. I haven't seen it used.
SQL*Net 2 1521 1521 Probably the most common Oracle port. Not registered to Oracle, IANA registered for ncube-lm, nCube License Manager.
SQL*Net 1 1525 1525 * Registered as orasrv. No longer used?
listener port 1526 1526 1526 is also a popular Oracle listener port, but it is also not IANA registered. In the IANA list, it is pdap-np, Prospero Data Access Prot non-priv.
tlisrv 1527 1527 *
coauthor 1529 1529 *
Oracle Remote Data Base 1571 1571 * rdb-dbs-disp
oraclenames 1575 1575 * Default and officially registered listening port for client connections to an Oracle Names server using TCP/IP or TCP/IP with SSL. Deprecated in 9i and above, you're supposed to use LDAP instead.
Oracle Net8 Cman 1630 1630 * oraclenet8cman. Default and officially registered listening port for client connections to Oracle Connection Manager
oracle-em1 1748 1748 *
oracle-em2 1754 1754 *
Oracle-VP2 1808 1808 *
Oracle-VP1 1809 1809 *
Oracle Net8 CMan Admin 1830 1830 * net8-cman. Default and officially registered listening port for administrative commands to Oracle Connection Manager
oracle?
2005 * registered as "berknet" for 2005 TCP, oracle for 2005 UDP
Oracle GIOP 2481 2481 * giop
Oracle GIOP SSL 2482 2482 * giop-ssl
Oracle TTC 2483 2483 * ttc. Oracle may use this port to replace 1521 in future.
Oracle TTC SSL 2484 2484 * ttc-ssl.
OEM Agent 3872 3872 * oem-agent
Oracle RTC-PM port 3891 3891 * rtc-pm-port
Oracle dbControl Agent 3938 3938 * dbcontrol_agent

Although incomplete, this is a pretty good article on the mess that is Oracle ports: Connecting with Oracle: Oracle Ports.

I also got some information from these copies of Oracle documentation Oracle9i Net Services Reference Guide Release 2 (9.2) and Oracle Database Net Services Reference Guide 10g Release 1 (10.1)

The Oracle Technology Network (OTN) should provide all the information you need, but I find it difficult to locate things there.

이올린에 북마크하기(0) 이올린에 추천하기(0)
"Oracle" 카테고리의 다른 글
2008/05/19 14:46 2008/05/19 14:46

맨 위로

피드백 : 트랙백 없음 | 댓글 1개

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

Oracle Error Code

이수안 데이터 연구실
Database/Oracle
2008/05/19 00:20, 글쓴이
ora-00000     ?깃났?
이올린에 북마크하기(0) 이올린에 추천하기(0)
"Oracle" 카테고리의 다른 글
2008/05/19 00:20 2008/05/19 00:20

맨 위로

피드백 : 트랙백 없음 | 댓글 2 개

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

Top 119 Cheat Sheets

이수안 데이터 연구실
Programming
2008/05/03 13:07, 글쓴이
Site : http://webdeveloper.econsultant.com/

ActionScript

Ajax

2008/05/03 13:07 2008/05/03 13:07

맨 위로

피드백 : 트랙백 없음 | 댓글 없음

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

Cheat Sheet?

이수안 데이터 연구실
Programming
2008/02/02 21:33, 글쓴이
Actionscript

Ajax

2008/02/02 21:33 2008/02/02 21:33

맨 위로

피드백 : 트랙백 없음 | 댓글 없음

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

?

이수안 데이터 연구실
Webdizen/Blog
2008/01/20 23:49, 글쓴이
MySQL, Sun?
이올린에 북마크하기(0) 이올린에 추천하기(0)
"Blog" 카테고리의 다른 글
  • ? (0)2009/01/26
  • ? (2)2008/06/16
  • 釉 (2)2008/04/22
  • ? (3)2008/04/19
  • ? (0)2008/01/30
  • ? (1)2008/01/20
  • ? (0)2008/01/13
  • ? (0)2008/01/06
  • 釉 (0)2007/11/29
2008/01/20 23:49 2008/01/20 23:49

맨 위로

피드백 : 트랙백 없음 | 댓글 1개

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

ADO Connection Strings

이수안 데이터 연구실
Programming/Database Programming
2007/07/10 09:57, 글쓴이
異
이올린에 북마크하기(0) 이올린에 추천하기(0)
"Database Programming" 카테고리의 다른 글
2007/07/10 09:57 2007/07/10 09:57

맨 위로

피드백 : 트랙백 없음 | 댓글 없음

이 글에 대한 피드백 구독 : 트랙백+댓글 | 트랙백 | 댓글

◀ recent | 1 | previous ▶