Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus ORA-12547 TNS: Lost contact TNS: 00517

Re: sqlplus ORA-12547 TNS: Lost contact TNS: 00517

From: George <george.cross_at_excite.com>
Date: 29 Nov 2004 09:48:32 -0800
Message-ID: <e1033c4c.0411290948.4a8a6c4f@posting.google.com>


Thanks for the responses.

It turns out, I was not using the correct arguments to sqlplus. It worked after I specified the right user, db, and pfile:

>sqlplus "SYS/change_on_install_at_el3lxr as sysdba" sqlplus>startup pfile="$ORACLE_HOME/dbs/initEL3LXR.ora"

I guess the db and pfile aren't right.

Sincerely,

George

veronica.pham_at_gmail.com wrote in message news:<de809b9e.0411251929.a414189_at_posting.google.com>...
> Dear Oracle comrades,
>
> I just installed OracleEE 8.1.7 on HP-UX11.00.
>
> I added all the recommended os patches, adjusted the shm* kernel
> params, rebooted, ran runInstaller and installed everything including
> the started db, which installed successfully. I then ran
>
> lsnrctl start
>
> and it started just fine. tnsping on my db name succeeds. But when I
> run sqlplus, it prompts me for my login id and password, (SYS,
> change_on_install) and then says,
>
> ORA-12457 TNS: Lost contact
>
> I look in the sqltns.log and it says TNS-00517 TNS: Lost contact.
>
> Is this related to shmmax at all? Any other ideas?
>
> Thank you very much for any help you can give this desparate poor
> soul...
>
> Sincerely, George
Received on Mon Nov 29 2004 - 11:48:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US