Using RAC environment to solve the sp2-1503 error of native Sqlplus

Source: Internet
Author: User
Tags dba ftp file permissions sqlplus

Failure phenomenon:

$ sqlplus/as SYSDBA

Sp2-1503:unable to initialize Oracle call interface

Sp2-0152:oracle May is functioning properly

Analysis: Online are said to be timezone and Timezlrg file permissions are not correct, but I do not have these two files,

What to do, and look at the following analysis

--See if TimeZone and Timezlrg files are normal

$ cd/home/oracle/database/oracore/zoneinfo

$ ls-lt

Total 16

-rw-r--r--1 Oracle DBA 4672 June 2006 Readme.txt

--missing, immediately thought of going to another node in RAC to fetch the file.

--ftp, go.

$ ftp 192.168.1.56

Connect to 192.168.1.56.

p550b FTP Server (Version 4.2 Tue Nov 12:49:19 CST 2006) ready.

Name (192.168.1.56:root): root

331 Password required for root.

Password:

230-last unsuccessful Login:thu Dec 10:43:55 beist from ON/DEV/PTS/4

230-last Login:fri Apr 1 09:27:15 beist on/dev/pts/1 from 192.168.180.29

230 User root logged in.

--access to the appropriate directory of the remote host

Ftp> Cd/home/oracle/database/oracore/zoneinfo

CWD command successful.

ftp> pwd

257 "/home/oracle/database/oracore/zoneinfo" is current directory.

Ftp> Get *.dat

How can--ftp not support ambiguity, first enter the detailed name to complete the task.

PORT command successful.

*.dat:no such file or directory

Ftp> Ls-lt

PORT command successful.

Opening data Connection For/bin/ls.

Total 1128

-rw-r--r--1 Oracle DBA 404884 2007 Timezlrg.dat

-rw-r--r--1 Oracle DBA 161123 2007 Timezone.dat

-rw-r--r--1 Oracle DBA 4672 June 2006 Readme.txt

Transfer complete.

--FTP Get remote Files

Ftp> Get Timezlrg.dat

PORT command successful.

Opening Data connection for Timezlrg.dat (404884 bytes).

Transfer complete.

4589539693338558464 bytes (5.93 million bytes/sec) received in 2.03e-318 seconds

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.