Start oracle on linux platform

2010-12-03  来源:本站原创  分类:Database  人气:95 

oracle linux platform above not start automatically, need manual, the specific operation is as follows

(A)

First start in command mode monitoring the following:

#> Lsnrctl start

This command will execute a long time, need to be patient, after the success of such a message will appear:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-DEC-2010 15:26:25

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting / opt/oracle/10.2.0/db_1/bin/tnslsnr: please wait ...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is / opt/oracle/10.2.0/db_1/network/admin/listener.ora
Log messages written to / opt/oracle/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1)))
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.16) (PORT = 1521)))

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2010 15:26:27
Uptime 0 days 0 hr. 3 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / opt/oracle/10.2.0/db_1/network/admin/listener.ora
Listener Log File / opt/oracle/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1)))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.16) (PORT = 1521)))
Services Summary ...
Service "PLSExtProc" has 1 instance (s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service ...
Service "kids21" has 1 instance (s).
Instance "kids21", status UNKNOWN, has 1 handler (s) for this service ...
The command completed successfully

(B)

Log in to sqlplus command mode

#> Sqlplus / nolog

(C)

Transferred to the database, this time, the database has not yet started, just started listening

sql> connect / as sysdba

This place, if you enter a user name and password is written:

sql> connect sys/kids21 connected in this way, then there may be an error:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

If you write something like this:

SQL> Connect sys/kids21 @ kids21 connected in such a way out of this error if possible:

ORA-12505: TNS: listener does not recognize the current connection descriptor SID given

Because there is so configured listener.ora:

# Listener.ora Network Configuration File: / opt/oracle/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = / opt/oracle/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.16) (PORT = 1521))
)
)

Need to add such a configuration in which:

# Listener.ora Network Configuration File: / opt/oracle/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = / opt/oracle/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = kids21)
(ORACLE_HOME = / opt/oracle/10.2.0/db_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.16) (PORT = 1521))
)
)

(D)

Start the database,

sql> startup

(E)

Start the tool connection, if there is

adapter not available

The error that the server's firewall turned on, set by

相关文章
  • Start oracle on linux platform 2010-12-03

    oracle linux platform above not start automatically, need manual, the specific operation is as follows (A) First start in command mode monitoring the following: #> Lsnrctl start This command will execute a long time, need to be patient, after the suc

  • Start the oracle on linux platform 2010-12-03

    top oracle linux platform not start automatically, you need to manually, as follows (A) In command mode following the first start the listener: #> Lsnrctl start This command runs longer need to wait, after the success of such a message will appear: L

  • install oracle 10g linux platform 2011-01-05

    1. Test system rhel 5.4 + oracle 10g r 2 System, there are c, c + + compiler environment, to install the following rpm rpm-ivh kernel-headers-2.6.18-164.el5.i386.rpm rpm-ivh compat-glibc-headers-2.3.4-2.26.i386.rpm rpm-ivh compat-glibc-2.3.4-2.26.i38

  • install oracle 10g linux Journey in <switch> 2010-09-07

    install oracle 10g linux A Journey Transfer from: http://edu.yesky.com/edupxpt/497/2154497.shtml Install oracle in linux is a daunting thing, far more than the complexity of installing linux operating system itself. If successful installation of orac

  • LINUX platform in oracle9i create database manually 2010-12-09

    http://hi.baidu.com/oracle_10g/blog/item/56773b7a04a317ef2e73b3ee.html System environment: 1, the operating system: Linux 2, the database: Oracle9I Release 9.2.0.3.0 Method of building a database to learn about oracle, though successful, but the clie

  • Oracle's Linux virtualization and cloud computing strategy 2011-05-17

    With the advantages of Linux and open source environment's influence on architecture in the open source virtualization is that many corporate users concerned about. Since 2007, virtualization technology in the Chinese market has become famous to Red

  • install oracle 10g linux 2011-08-12

    Install oracle on linux is a daunting thing, far more than the complexity of the installation of linux operating system itself. If you can successfully install the oracle, then the way while also mastered a number of linux technology. This article de

  • Manually create the database on a LINUX platform oracle9i 2010-12-09

    http://hi.baidu.com/oracle_10g/blog/item/56773b7a04a317ef2e73b3ee.html System environment: 1, the operating system: Linux 2, Database: Oracle9I Release 9.2.0.3.0 Learn about building a database oracle method, although successful, but the client does

  • In the Linux platform using the JNI 2010-03-29

    This carried over: http://www.ibm.com/developerworks/cn/java/l-linux-jni/ In the Linux platform using the JNI Document options <script type="text/javascript"> </ script> <noscript> </ noscript> <noscript> </ nosc

  • Linux platform to achieve high availability program DRBD 2010-03-03

    Linux platform to achieve high availability DRBD DRBD program is actually a piece of equipment to achieve, primarily used for Linux platform for high availability (HA) programs. He is a kernel module and related procedures which consists of a network

  • Oracle 10G Linux host configuration automatically start the next memo 2010-04-12

    Oracle 10G Linux host configuration automatically start the next process credit, use the root user to modify / etc / oratab file: $ Gedit / etc / oratab orcl: / oracle/app/product/10.2.0/db_1: N Read: orcl: / oracle/app/product/10.2.0/db_1: Y That is

  • Linux platform to create and use user function library pdf document 2010-05-02

    Described in detail how the Linux platform to create and use the user function library, is a pdf document

  • In the Linux platform debugging C / C + + memory leak method 2010-08-06

    Since C and C + + programs completely independent application and release by the programmer memory, little carelessness will import a memory error in the system. Meanwhile, the memory errors are often very serious, the general will bring such as syst

  • Remote COPY / open linux platform ftp / telnet services 2010-11-05

    Remote COPY scp [email protected]: / root / firewall.tar.gz. / scp / home / cheney / full.tar.gz [email protected]: / home / root / scp-r [email protected]: / mail / *. / (copy all the files in the directory) Need to enter the appropriate user name and password

  • AIR on the Linux platform support for certificate authentication [Translation] 2010-12-05

    Original: Certificate Support in AIR for Linux In an earlier article describes how to use TLS on the AIR applications on Windows and the Mac platform, client authentication . Arlen asked how the reader on a Linux platform, the same work, unfortunatel

  • Deployment Guide for DB2 install Linux platform 2010-12-21

    Deployment Guide for DB2 install Linux platform

  • MYSQL Installation Deployment Guide Linux platform 2010-12-21

    MYSQL Installation Deployment Guide Linux platform

  • Oracle Enterprise Linux distribution kernel 2011-05-17

    Oracle has announced Oracle Linux added as a fast, modern, reliable Unbreakable Enterprise Kernel kernel, you can quickly optimize the performance of Oracle software and hardware. Oracle Linux and virtualization projects, senior vice president Wim Co

  • Linux platform installation Informix Dyanmic Server 10 2011-05-26

    Linux platform installation Informix Dyanmic Server 10.00.UC4 The first step, installing the necessary packages (RH AS3) gcc and c + + compiler 3.2.3 compat-gcc-7.3 compat-gcc-c + + -7.3 compat-libstdc + + -7.3 glibc-devel-2.3.2 libaio-0.3.96 libgcc-

  • Remote COPY / on linux platform ftp / telnet services 2010-11-05

    Remote COPY scp [email protected]: / root / firewall.tar.gz. / scp / home / cheney / full.tar.gz [email protected]: / home / root / scp-r [email protected]: / mail / *. / (copy all files in the directory) Need to enter the appropriate user name and password Secu