Installation of the Solaris Oracle database

Source: Internet
Author: User
Tags sqlplus

Reference: http://blog.csdn.net/nemo2011/article/details/8183326Solaris Adding a new hard disk

http://blog.163.com/[email protected]/blog/static/35166181200942351523927/ in Solaris installation under System Oracle10 Summary ??

http://blog.163.com/[email protected]/blog/static/35166181200942351523927/ SOLARIS10 installed on the Oracle9201??

?

Preparatory work:

PATH

By completing the above 5 parts, you can install Oracle.

Graphical interface, be sure to log in with the Oracle user, do not log in with root, and then su to the Oracle user, this will fail to log in.

It is verified that 32-bit Solaris cannot install 64-bit Oracle software.

Http://wenku.baidu.com/link?url=iXWTWpFZceD-TEKPO919x5Gm-ZLchJ4FmYoul5Zz4xFk--qC0XxKHMrQrL7CsE2C3f_ zdfks8tixykunoao9fysrenr1ep5fkmnykkmda6e Oracle for Solaris installation Error FAQ

?

Reference: http://www.itpub.net/thread-1849937-1-1.htmlOracle11gR2 corresponding the Solaris version of the Solaris (x86-64) version of the operating system is:

?

Solution:

    1. Change system
    2. Change Oracle 10g 32-bit

The following scenario 2, for Oracle 10g, we need to go inside the window browser Bing inside to search. The URL is as follows:

Www.linuxidc.com/Linux/2015-02/113620.htm

?

?

?

?

Second, install the Oracle 11g tutorial on Redhat

Resources:

http://blog.163.com/dongfang_1226/blog/static/5867778020126281245271/ RedHat Linux installation oracle11g?

?

Since some software needs to be installed during the Solaris installation, the previous image file is not loaded, so we need to download the ISO file and install some dependent files from it.

http://blog.chinaunix.net/uid-18997108-id-273965.htmlRHEL5.1 Installing the GCC compilation environment to resolve dependency issues

http://www.linuxidc.com/Linux/2011-09/43704.htm Red Hat Enterprise Linux Server 6.0 official multi-language CD image download

?

?

Follow the procedure above to install the database system:

Some software is not installed directly ignored, directly installed on the line.

After the installation is complete, enter:

Start monitoring Lsnrctl Start

Starting the database and instance Sqlplus/nlog conn/as SYSDBA

SQL > Startup

?

For the CRT side, we can log on with Oracle, and none of the other users.

?

What happens when you encounter this error?

Solution:

http://blog.csdn.net/zhanghai412/article/details/7947460ora-01034:oracle not available

Mainly because there is no startup, enter, we can see a lot.

?

Database Password: Db123456 The user name is the same as on the installation.

?

If you need to remotely connect to the database above the machine: (How to connect Oracle above Linux in Windows)

  • : http://www.d9soft.com/soft/107044.htm
      • Oracle Database client11gr2 Lite download above tested, 64-bit systems cannot be installed, only with official Win32_11gr2_client.zip

    Pl-sql used a plsql+developer10.0.5.1710chinese.rar.

    Reference: http://jingyan.baidu.com/article/22a299b51741df9e19376a90.html plsql Developer Win7 64-bit installation method

    ?

    Reference:http://zhidao.baidu.com/link?url= 1gyvbv3xcqeenig3vt3kf5ocvmmahsnmotd7hw-ldrigy21bacuq0wqn-wqo9m8bbxpl0nh7_o2yggmqklszga

    About the relationship between oracle10g, Oracle client, and Plsql devement

    ORACLE10G is a server, if the native installation of Oracle 10g, there is no need to install Oracle client, only configure DNS, you can use the Plsql development connection.

    Oracle Client Client face Database administration Tools, configuration DNS tools such as native servers are not installed oracle10g need to install Oracle Client to access the server

    Plsql devementDatabase Tools ConfigurationDNSto usePlsql devementconnect to the database. Plsql developer?oraclethird software must beOracleClientTo support or installOraclefor service machinesClientUsePlsql devementConnect to the database (configureDNS).

    ?

    Below for Windows, connect Linux above the Oracle to do a problem description:

    Reference: http://www.itpub.net/thread-1235943-4-1.html You can connect to Oracle on a virtual machine under Windows database? (This article is most useful)

    http://www.cnblogs.com/ymj126/p/3712727.html PL/SQL Developer connect local Oracle 11g Database

    http://www.cnblogs.com/kane1990/p/OracleNetManager.htmlOracle Net Manager service naming configuration and PL/SQL Landing Database

    ?

    ?

    Summary article:

    Here are the specific configuration steps:

    1. Install Oracle database under Linux, the database can be downloaded from official website, this environment uses Oracle R2.
Reference article:http://blog.163.com/dongfang_1226/blog/static/5867778020126281245271/ RedHat Linux installation oracle11g?
    1. Because it is an Oracle installed on Linux, it can be assumed that this version is server-side, if we want to telnet to this server, we need to install the client and third-party operations database software.

      Download Oracle_client (with the Win32 version, my system for 64-bit machines), and PL/SQL 32-bit, which is described above.

Reference: Http://www.cnblogs.com/ymj126/p/3712727.html solves 64-bit machines and installs PL/SQL issues.

http://www.cnblogs.com/kane1990/p/OracleNetManager.html resolves the issue of configuring TNS servers with Oracle.

  1. Install the two software mentioned in 2, (install Oracle_clint will have the option to select a full version.) Install the PL/SQL installation directory, do not have the Word program file (x86), PL/SQL is not recognized). After the

    is complete, use the net manager inside Oracle_client to configure the TNS service, as well as the PL/SQL service. The

    is as follows:

    Configuration in Windows: (Tnsnames.ora is automatically shown through the Net Manager configuration, this file is actually a mapping relationship, which is implemented in the way of key-value pairs.) Of course,

    We can also not install the oracle_client can also, after extracting, the inside of the file directly configured, so that it does not have to install.

    Tnsnames.ora content:

    # Tnsnames.ora Network Configuration file:e:\app\zhuxuekui\product\11.2.0\ Client_1\network\admin\tnsnames.ora

    # Generated by Oracle configuration tools.

    ?

    ORCL =

    (DESCRIPTION =

    (address_list =

    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.132.11) (PORT = 1521))

    )

    (Connect_data =

    (service_name = ORCL)

    )

    )

    ?

    Plsql Configuration:

    (when Plsql is active, long spaces are filled in long strings)

    ?

    ?

  2. How to connect a database above Linux

    DOS authentication: tnsping sys/[email protected] as Sysdba

    1) Both sides of the firewall problem (if the side of the firewall is open, then under DOS, will prompt time out)

    Solution: Under Windows good processing, directly shut down the firewall.

    Linux for security reasons, you can only shut down a port's firewall.

Reference: http://bbs.chinaunix.net/thread-2187037-1-1.html How to turn off the Linux default firewall

Method One: Close or open a firewall: chkconfig–level xxx iptables on/off

View: Chkconfig–list|grep iptables

Method Two: Service iptables start/stop

?

To configure the firewall:

-A input–m state–state new–m tcp–p tcp–dport 1521–j ACCEPT allows 1521 ports to pass through the firewall, where the location is placed under the default 22 port rule.

After the configuration is complete, restart the firewall. /etc/init.d/iptables restart

(Below this table below/etc/sysconfig/iptables)

?

When the firewall is right, this should be the case, Chkconifg–list|grep iptables, because I use ETH6, but he is closed, so DOS does not appear in the timeout error.

2) In addition to the firewall problem, there is the Linux side of the Listener program configuration file

Must be configured, the file location installation directory below the network

Reference: can I connect to the Oracle database on my virtual machine under Windows ? This is not configured Well, there will be no listener error.

?

Solution:

    1. Configuration file

      Use the TAB key and Bing search engine flexibly.

      Be sure to configure the SID or the instance cannot be found.

    2. Turn on the monitoring service

      Make sure the service ORCL has 1 instance is successful, otherwise, such as the presence of no service is a failure.

      Review the status to configure the success.

    1. About login, password retrieval and other issues.

      Workaround: Connection as SYS should be as SYSDBA or sysoper problem.

      Reference: http://bbs.csdn.net/topics/350111348

      Login: Sqlplus sys/[email protected] as Sysdba

      FIX: Forgot password, password unlocked problem.

      Reference: http://blog.csdn.net/devillyd/article/details/7219817

      Sqlplus/as SYSDBA

Installation of the Solaris Oracle database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.