Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

starting Oracle 11gr2 Im getting Error: ORA-03135: connection lost contact

Dan8Dec 4 2013 — edited Dec 5 2013

Hi Guys!

Thanks for your advises. I still working toward a resolution.

But I encountered another issue from Enterp Manager :

ERROR : Please correct the following error: Connection string must be specified.

My connection has this format:

//using connection string attributes to connect to Oracle Database

con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle";

con.Open();

Console.WriteLine("Connected to Oracle" + con.ServerVersion);

Please tell me what is wrong here. Thanks. Dan.

Hi all !

I need help please for resolving the following :

Problem:

Im having frequent disconnection after abnormal shutdown due to power failure.

starting Oracle 11gr2 Im getting Error: ORA-03135: connection lost contact

Im on Laptop running Linux Centos 6.3 Host.

and Im running Oracle 11gr2 on Oracle Enterprise Linux in VMware (Guest).

When attempting login from the Oracle Enterprise Manager Database Control

I got Error: "Your username and/or password are invalid."

The alert.log is at the bottom

[test@localhost ~]$ xhost +

access control disabled, clients can connect from any host

[test@localhost ~]$

[test@localhost ~]$ su - root

Password:

[root@localhost ~]#

[root@localhost ~]# su - oracle

[oracle@localhost ~]$

[oracle@localhost ~]$ export ORACLE_SID=db11gr2

[oracle@localhost ~]$

[oracle@localhost ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/db_1

[oracle@localhost ~]$

[oracle@localhost ~]$ echo $ORACLE_BASE

/u01/app/oracle

[oracle@localhost ~]$

[oracle@localhost ~]$ echo $ORACLE_SID

db11gr2

[oracle@localhost ~]$

[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2013 12:23:07

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 04-DEC-2013 12:23:08

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Services Summary...

Service "db11gr2" has 1 instance(s).

Instance "db11gr2", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@localhost ~]$

[oracle@localhost ~]$ emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

https://localhost.localdomain:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ............... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_db11gr2/sysman/log

[oracle@localhost ~]$

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 4 12:26:38 2013

Connected to an idle instance.

SQL> shutdown abort;

ORACLE instance shut down.

SQL>

SQL> startup;

ORACLE instance started.

Total System Global Area 799313920 bytes

Fixed Size 1339484 bytes

Variable Size 318771108 bytes

Database Buffers 473956352 bytes

Redo Buffers 5246976 bytes

Database mounted.

ORA-00600: internal error code, arguments: [4194], [: no

SQL> startup;

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL>

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@localhost ~]$

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 4 12:59:23 2013

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area 799313920 bytes

Fixed Size 1339484 bytes

Variable Size 318771108 bytes

Database Buffers 473956352 bytes

Redo Buffers 5246976 bytes

Database mounted.

Database opened.

SQL>

ERROR at line 1:

ORA-03135: connection lost contact

Process ID: 8973

Session ID: 1 Serial number: 5

SQL> startup;

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL>

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@localhost ~]$

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 4 13:12:03 2013

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area 799313920 bytes

Fixed Size 1339484 bytes

Variable Size 318771108 bytes

Database Buffers 473956352 bytes

Redo Buffers 5246976 bytes

Database mounted.

Database opened.

SQL>

SQL> select STATUS, DATABASE_STATUS from v$instance;

STATUS DATABASE_STATUS

------------ -----------------

OPEN ACTIVE

SQL>

SQL> SELECT * FROM v$instance;

ERROR:

ORA-03114: not connected to ORACLE

[oracle@localhost ~]$

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 4 13:17:37 2013

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area 799313920 bytes

Fixed Size 1339484 bytes

Variable Size 318771108 bytes

Database Buffers 473956352 bytes

Redo Buffers 5246976 bytes

Database mounted.

Database opened.

SQL>

SQL> SELECT * FROM v$instance;

INSTANCE_NUMBER INSTANCE_NAME

--------------- ----------------

HOST_NAME

----------------------------------------------------------------

VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT

----------------- --------- ------------ --- ---------- ------- ---------------

LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO

---------- --- ----------------- ------------------ --------- ---

1 db11gr2

localhost.localdomain

11.2.0.1.0 04-DEC-13 OPEN NO 1 STOPPED

ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

SQL>

--------------------------------------------

alert log file

[oracle@localhost ~]$

[oracle@localhost ~]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Wed Dec 4 17:09:47 2013

ADR base = "/u01/app/oracle"

adrci> set editor emacs

adrci> show alert

Choose the alert log from the following homes to view:

1: diag/rdbms/unknown/DB11G

2: diag/rdbms/db11gr2/db11gr2

3: diag/tnslsnr/localhost/listener

Q: to quit

Please select option: 2

*** glibc detected *** adrci: malloc(): memory corruption: 0x09de7160 ***

======= Backtrace: =========

/lib/libc.so.6[0x1d42dd]

/lib/libc.so.6(__libc_malloc+0x67)[0x1d5e97]

/lib/ld-linux.so.2[0x331f8a]

/lib/ld-linux.so.2[0x33215a]

/lib/ld-linux.so.2[0x32e3ce]

/lib/libc.so.6[0x272550]

/lib/libc.so.6(_dl_sym+0x1a)[0x2728fa]

/lib/libdl.so.2[0x110e08]

/lib/ld-linux.so.2[0x331e66]

/lib/libdl.so.2[0x1112cc]

/lib/libdl.so.2(dlsym+0x63)[0x110d93]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(sskgds_save_text_start_end+0x47)[0xa0fb37]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(skgdsinit+0xb7)[0xa0a909]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x15edea8]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(kgdsdsts+0x26)[0x15ef8c2]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgemdGetCallStackWFlag+0x102)[0x198961a]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgemdGetCallStack+0x2d)[0x198950d]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1989250]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgemdFillIncCtx+0x72)[0x1989088]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgexPopulateIncCtx+0x67)[0x1994d25]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgexProcessError+0x75)[0x1996437]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x19601c5]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgePostErrorDirect+0x650)[0x1960b3c]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1c58fb6]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x183c44e]

[0x3bb440]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1cf7966]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgrlrReadAlertMsg+0x562)[0x1cf7126]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgrxae_alert_ext+0x2d4)[0xbbcf44]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0xb9f25c]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgrmqmf_fetch_real+0x23f)[0xb9bc1f]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgrmqmf_fetch+0xee)[0xb9b520]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0xb53c3e]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgrip_relation_iterator+0x16c)[0xb531bc]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgripricm_rltniter_wcbf_mt+0x1f7)[0xb52709]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgripritc_rltniter_wcbf+0xe6)[0xb585f2]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgvm_query+0x3f2)[0x1abe62c]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgvm_query_wcmd+0x36f)[0x1abf053]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1c3e116]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1c3f5b7]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1[0x1c4e2ae]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgvciec_exec_cmd+0x4a2)[0x1c4d640]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(dbgvci_main_int+0x43b)[0x1c59e61]

adrci[0x8048c5b]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(lpmcall+0x363)[0x1496ec3]

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1(lpmpmai+0x15c)[0x1497904]

adrci[0x8048aa5]

/lib/libc.so.6(__libc_start_main+0xdc)[0x17fe9c]

adrci[0x8048811]

======= Memory map: ========

00110000-00112000 r-xp 00000000 08:03 5925240 /lib/libdl-2.5.so

00112000-00113000 r-xp 00001000 08:03 5925240 /lib/libdl-2.5.so

00113000-00114000 rwxp 00002000 08:03 5925240 /lib/libdl-2.5.so

00114000-00139000 r-xp 00000000 08:03 5925284 /lib/libm-2.5.so

00139000-0013a000 r-xp 00024000 08:03 5925284 /lib/libm-2.5.so

0013a000-0013b000 rwxp 00025000 08:03 5925284 /lib/libm-2.5.so

0013b000-0014f000 r-xp 00000000 08:03 5925246 /lib/libpthread-2.5.so

0014f000-00150000 r-xp 00013000 08:03 5925246 /lib/libpthread-2.5.so

00150000-00151000 rwxp 00014000 08:03 5925246 /lib/libpthread-2.5.so

00151000-00153000 rwxp 00151000 00:00 0

00153000-00166000 r-xp 00000000 08:03 5925301 /lib/libnsl-2.5.so

00166000-00167000 r-xp 00012000 08:03 5925301 /lib/libnsl-2.5.so

00167000-00168000 rwxp 00013000 08:03 5925301 /lib/libnsl-2.5.so

00168000-0016a000 rwxp 00168000 00:00 0

0016a000-002a9000 r-xp 00000000 08:03 5925233 /lib/libc-2.5.so

002a9000-002aa000 --xp 0013f000 08:03 5925233 /lib/libc-2.5.so

002aa000-002ac000 r-xp 0013f000 08:03 5925233 /lib/libc-2.5.so

002ac000-002ad000 rwxp 00141000 08:03 5925233 /lib/libc-2.5.so

002ad000-002b0000 rwxp 002ad000 00:00 0

002b0000-002b1000 r-xp 00000000 08:03 3905250 /usr/lib/libaio.so.1.0.1

002b1000-002b2000 rwxp 00000000 08:03 3905250 /usr/lib/libaio.so.1.0.1

002b2000-002bb000 r-xp 00000000 08:03 5925256 /lib/libnss_files-2.5.so

002bb000-002bc000 r-xp 00008000 08:03 5925256 /lib/libnss_files-2.5.so

002bc000-002bd000 rwxp 00009000 08:03 5925256 /lib/libnss_files-2.5.so

002bd000-002c8000 r-xp 00000000 08:03 5925425 /lib/libgcc_s-4.1.2-20080825.so.1

002c8000-002c9000 rwxp 0000a000 08:03 5925425 /lib/libgcc_s-4.1.2-20080825.so.1

00324000-0033e000 r-xp 00000000 08:03 5925219 /lib/ld-2.5.so

0033e000-0033f000 r-xp 00019000 08:03 5925219 /lib/ld-2.5.so

0033f000-00340000 rwxp 0001a000 08:03 5925219 /lib/ld-2.5.so

003bb000-003bc000 r-xp 003bb000 00:00 0 [vdso]

003bc000-01fc3000 r-xp 00000000 08:03 4984633 /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

01fc3000-020a7000 rwxp 01c07000 08:03 4984633 /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

020a7000-020c1000 rwxp 020a7000 00:00 0

025b1000-027ce000 r-xp 00000000 08:03 5006042 /u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.so

027ce000-027fc000 rwxp 0021d000 08:03 5006042 /u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.so

027fc000-027fe000 rwxp 027fc000 00:00 0

08048000-08049000 r-xp 00000000 08:03 1407670 /u01/app/oracle/product/11.2.0/db_1/bin/adrci

08049000-0804a000 rw-p 00000000 08:03 1407670 /u01/app/oracle/product/11.2.0/db_1/bin/adrci

09d62000-09e0d000 rw-p 09d62000 00:00 0 [heap]

b7e00000-b7e21000 rw-p b7e00000 00:00 0

b7e21000-b7f00000 ---p b7e21000 00:00 0

b7f68000-b7f90000 rw-p b7f68000 00:00 0

bfc54000-bfc6d000 rwxp bffe5000 00:00 0 [stack]

bfc6d000-bfc6e000 rw-p bfffe000 00:00 0

starting Oracle 11gr2 Im getting Error: ORA-03135: connection lost contact

Im on Laptop running Linux Centos 6.3 Host.

and Im running Oracle 11gr2 on Oracle Enterprise Linux in VMware (Guest).

Im having frequent disconnection after abnormal shutdown due to power failure.

When attempting login from the Oracle Enterprise Manager Database Control

I got Error: "Your username and/or password are invalid."