Re: [Re: Connection Problem]

hello

the log destination directory where lsnr generates log does not have writ= e
permissions other than oracle user it seems. please give write permission=  to
the user you are logging in for running lsnr & try.

hope this solves the problem

Jay

"Giri Gajjela" <yadagiri.gajjela_at_wipro.com> wrote: Hi,

    I copied the .profile of Oracle user. But still its giving the same problem.

Giri
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 31, 2000 10:30 PM

Hi

U need to set path for /usr/ccb/bin. check metalink for an article on thi= s.
it has a checklist on what u are supposed to check and do.

in this case u can check the path variables (including ld_library_path) f= or
the oracle user and use the same in the other user.

hth

babu

Giri Gajjela <yadagiri.gajjela_at_wipro.com>@fatcity.com on 10/31/2000 12:30:25 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Hi All,

While connecting to Oracle Database with an id other than Oracle i am getting the
following problem

ld.so.1: oracleEMPLOY: fatal: libobk.so: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

When I start Listener using the same id i am facing the foll. problem

bash-2.03$ lsnrctl start

LSNRCTL for Solaris: Version 8.0.6.0.0 - Production on 30-OCT-00 21:30:5= 5

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Starting /export/home1/oracle8/product/8.0.6/bin/tnslsnr: please wait...=

TNSLSNR for Solaris: Version 8.0.6.0.0 - Production NL-00280: error creating log stream
/export/home1/oracle8/product/8.0.6/network/ log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Solaris Error: 13: Permission denied

While connecting using Oracle Id i am able to connect without any proble= m.

What could be the problem? I think there would be some permission problems.

TIA
Giri

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Babu.Nagarajan_at_Cummins.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- =

Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- =

Author: Giri Gajjela
  INET: yadagiri.gajjela_at_wipro.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).


____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=3D=
1


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

 From: RanganathK_at_lgcommerznow.com
 Date: Sat, 4 Nov 2000 10:11:23 +0530
 Subject: Unix problem - Urgent help required

Dear all,

     I have a problem On Sun Solaris 2.6.  One of my filesystems/partitions
was showing as 100% full.  So I moved some of the directories and files to
the other partition.  Then also this filesystem was showing as 100% full.
So I thought that may be by shutting down and restarting the machine the
filesystem will show some free space.  But after shutting down and
restarting the machine I observed this particular filesystem is not
mounting and it was booting in single user mode and asking me to run fsck
as the filesystem is inconsistent.  But even after running fsck I observed
that the filesystem was not mounting.  Can anyone help me in getting the
filesystem mounted.  Any help in this regard will be very much appreciated.

TIA,

Ranganath



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

 From: Nobody Win <application_erp_at_yahoo.com>
 Date: Fri, 3 Nov 2000 21:37:18 -0800 (PST)
 Subject: Soory For 9i

Hi All,
I am really soory for this silly mistake which i done
on this list i again list this documebt but in
diffrent
format and why yahoo dont scan this doc i use the
antivirus and i dont understand why it is in binary.

Soory to all.

This is the real Story of Oracle 9i.
ORACLE 9i SERVER 

Oracle9i continues Oracle8i's focus on the Internet by
providing a series of specific capabilities and
product bundlestargeted at eBusiness environments. In
addition, Oracle9i continues to add features and
capabilities that extends existing investment in
mission-critical infrastructure. Oracle9i has been
designed with focus on certain key development areas.



LogMiner has also been enhanced in Oracle9i to provide
comprehensive Log Analysis for all data types.
LogMiner now supports index organized and clustered
tables, chained rows, LOBs and LONGs, direct loads,
scalar object types, and DDLs. LogMiner also displays
the primary key, and supports queries on the logs
based on content of change (for example, show all
changes to employee 'Smith'). A new graphical user
interface as well as other database features also make
the product easier to both learn and use.


ONLINE DATA EVOLUTION
Oracle9i contains a new online reorganization and
redefinition architecture that allows much more
powerful reorganization capabilities. Administrators
can now perform a variety of online operations to
table definitions, including online reorganization of
conventional tables. Essentially, Oracle9i now allows
an online "CREATE TABLE AS SELECT" operation.
In this new architecture the contents of the table are
copied into a new table. While the contents are
copied, the updates to the original table are tracked
by the database. After the copy completes, the updates
are applied to the new table. Once the updates are
applied, indexes can be created on the new table.
After the indexes are created, any additional updates
are applied and the result table replaces the original
table. The table is only locked in exclusive mode at
the beginning and of the operation while the
dictionary data is updated.
Using this new architecture, any physical attribute of
the table can be changed online. The table can be
moved to a new location, the table can be partitioned,
the table can be converted from one organization (e.g.
heap) to another (e.g. index organized).

Additionally, many logical attributes can be changed.
Column names, types, and sizes can be changed. Columns
can be added, deleted, or merged. The primary
restriction is that the primary key of the table
can.not be modified.

Oracle9i now also supports online create, rebuild,
etc. of secondary indexes on index organized tables.
Indexes can now be created online and analyzed at the
same time. Secondary indexes support efficient fixing
of block hints.
Administrators are also able to rapidly quiesce the
database in order to perform operations that demand no
active transactions. Also, with Oracle9i the buffer
cache and shared pool can be resized dynamically.
Lastly, Oracle9i can also validate the structure of an
object (Analyze Validate) while the object is online
and accessed by users








PRECISION DATABASE REPAIR


Oracle9i includes better prevention and improved
handling of disk corruption. Should a block corruption
need to be repaired via media recovery, a new block
media recovery feature allows only the corrupt blocks
to be recovered while the remainder of the table is
online. Oracle9i is able to restore the database to a
consistent state after log corruption is detected
during recovery. LogMiner allows changes in the log
after the corruption to be retrieved and applied.
Trial recovery allows recovery to proceed after a
corrupted database block is detected so that the
administrator can determine if the corruption is an
isolated event. If more corruption's are found, the
recovery can be backed out.


Oracle9i can also recover from crashes more quickly
using a new two-pass recovery algorithm that ensures
that only the blocks that need be processed are read
from and written to the datafiles. A new time-based
mean time to recover (MTTR) parameter also makes it
much easier to set a limit on crash recovery time.
Recovery Manager backup and restore operations can now
restart where they left off after a failure.


SELF SERVICE ERROR CORRECTION
Oracle9i contains very powerful techniques for
handling human errors.

The DejaView feature of Oracle9i allows data to be
queried from a point in the past. Users set the date
and time that they would like to view, and then any
SQL query that they execute will operate on data as it
existed at that point in time. This new capability
uses Oracle's multiversion readconsistency
capabilities to restore data by applying undo as
needed. Administrators can now configure undo
retention by simply specifying how long undo should be
kept in the database. Using DejaView, a user can query
the database as it existed this morning, yesterday, or
last week. The speed of this operations depends only
on the amount of data being queried and the number of
changes to the data that need to be backed out.
Using LogMiner, the change history of a database can
be queried from the logs. LogMiner now allows content
based data filtering. For example, users can query
just the changes to the customer John Smith. This
capability enables change history to be queried at the
row level. Since Redo and Undo are maintained by the
database for internal consistency, enabling these
capabilities adds no overhead.

INCREASED TRANSACTION THROUGHPUT ON ORACLE PARALLEL
SERVER
The completion of Cache Fusion in Oracle9i allows