How to rellocate Sun Solaris disk space where oracle installed

Paul

Hi:

I am totally new in Sun Solaris. I am not sure someone would like to
tell me how to rellocate Sun Solaris disk space where oracle
installed?

I installed Oracle 8i in Sun Solaris and set Oracle main table space
called TABLES in unix disk space /dpp/live01. From the following, it's
quite easy to see that the disk space of /dpp/live01 is 97%.Therefore
how can i move some disk space of SWAP to /dpp/live01 without losing
any Oracle data?

Millions thanks!
Paul

df -lk

Filesystem kbytes used avail capacity Mounted on
/dev/md/dsk/d0 686767 577098 54728 92% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
/dev/md/dsk/d100 289207 119099 141188 46% /export/home
/dev/md/dsk/d150 1015679 194846 759893 21% /dpp/live04
/dev/md/dsk/d200 3451518 3154010 228478 94% /tpp/oracle
/dev/md/dsk/d250 1559175 1247784 249024 84% /app/first
/dev/md/dsk/d300 4103598 3050582 1011981 76% /spp/spool
/dev/md/dsk/d350 3077262 2767475 309787 90% /dpp/live02
/dev/md/dsk/d400 3077262 2960587 116675 97% /dpp/live01
/dev/md/dsk/d450 3077262 2767491 309771 90% /dpp/test02
/dev/md/dsk/d500 3070782 2877507 193275 94% /dpp/test01
/dev/md/dsk/d550 113719 42314 60034 42% /dpp/live03
/dev/md/dsk/d600 113719 42330 60018 42% /dpp/test03
/dev/md/dsk/d700 866575 808939 0 100% /dpp/setup
swap 4656432 256 4656176 1% /tmp

Jul 19 '05 #1

Subscribe Reply

4478

hrishy

Hi Paul

Read up the oracle docos on how to move a datafile or relocate a
datafile .More importantly alter database rename datafile somethin
like that.Hope you understand oracle i guess..

regards
Hrishy

ji***********@y ahoo.com (Paul) wrote in message news:<f2******* *************** ****@posting.go ogle.com>...

Hi:

I am totally new in Sun Solaris. I am not sure someone would like to
tell me how to rellocate Sun Solaris disk space where oracle
installed?

I installed Oracle 8i in Sun Solaris and set Oracle main table space
called TABLES in unix disk space /dpp/live01. From the following, it's
quite easy to see that the disk space of /dpp/live01 is 97%.Therefore
how can i move some disk space of SWAP to /dpp/live01 without losing
any Oracle data?

Millions thanks!
Paul
df -lk

Filesystem kbytes used avail capacity Mounted on
/dev/md/dsk/d0 686767 577098 54728 92% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
/dev/md/dsk/d100 289207 119099 141188 46% /export/home
/dev/md/dsk/d150 1015679 194846 759893 21% /dpp/live04
/dev/md/dsk/d200 3451518 3154010 228478 94% /tpp/oracle
/dev/md/dsk/d250 1559175 1247784 249024 84% /app/first
/dev/md/dsk/d300 4103598 3050582 1011981 76% /spp/spool
/dev/md/dsk/d350 3077262 2767475 309787 90% /dpp/live02
/dev/md/dsk/d400 3077262 2960587 116675 97% /dpp/live01
/dev/md/dsk/d450 3077262 2767491 309771 90% /dpp/test02
/dev/md/dsk/d500 3070782 2877507 193275 94% /dpp/test01
/dev/md/dsk/d550 113719 42314 60034 42% /dpp/live03
/dev/md/dsk/d600 113719 42330 60018 42% /dpp/test03
/dev/md/dsk/d700 866575 808939 0 100% /dpp/setup
swap 4656432 256 4656176 1% /tmp

Jul 19 '05 #2

Similar topics

1799

Using Oracle on Solaris

by: Dale Strickland-Clark | last post by:

I need to write a tiny little program which makes use of an Oracle database on Solaris. Just a single SQL statement. Nice and simple. Coming from a Windows/SQLServer/ADO background, I'm having a bit of trouble finding some of the basics. Given that I already have Oracle and Python installed on the Solaris box, what else do I need? A little code snippet would be very handy.

Python

6295

problem with getting out of disk space error when viewing asp.net pages

by: Jas Shultz | last post by:

I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's very odd. Usually, I can just remove the application and readd it from the properties menu in the IIS...

ASP / Active Server Pages

1686

MySQL 5 alpha and Solaris 9 Client Fault

by: Robert Mazur | last post by:

Solaris 9 - sparc 64bit MySQL 5.0 alpha (installed using binary from MySQL) --------------------------------- Has anyone expereinced this? The client will launch locally and process SQL queries. However when using the up arrow to view previously entered SQL statements, the MySQL client throws: Segmentation Fault (core dumped)

MySQL Database

2483

Getting "not enough disk space error" when there is plenty of disk space

by: Jas Shultz | last post by:

ASP.NET

9738

compiling perl 5.8.7 on Solaris 8

by: Kirt Loki Dankmyer | last post by:

So, I download the latest "stable" tar for perl (5.8.7) and try to compile it on the Solaris 8 (SPARC) box that I administrate. I try all sorts of different switches, but I can't get it to compile. I need it to be compiled with threads. Anyone have any wisdom on how best to do this? Here's a transcript of my latest attempt. It's long; you might want to skip to the bottom, where I try "make" and the fatal errors start happening.

Perl

16064

"not enough space on disk" even though there is 35 gigs free

by: Jas Shultz | last post by:

I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. I have 35 Gigs of disk space free. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's very odd. Usually, I can just remove the application and readd it...

.NET Framework

1665

Python Oracle Interace on Solaris

by: kenneth.s.chan | last post by:

I am trying to use Python to do queries on a Oracle database using a Solaris box. I have seen tools such as cx_Oracle which would be good except that my Solaris box does not have an Oracle installation. Do I need to have an Oracle installation on my Solaris box to access the Oracle database (which is on another machine)? Are there ways to access an Oracle database and do queries without having a local copy of Oracle installed? Thanks.

Python

2511

long type in solaris

by: silvia.fama | last post by:

Hi! I'm using c language. I need to copy a long type value into a char string using a memcpy function: memcpy(string, (long *) value, len) this value will be then insert into a database. On windows machine it works well, on Solaris not. The windows and solaris path into c language is the same. I'd like to say also that real value works correctly also if they are

C / C++

199

How to rellocate Sun Solaris disk space where oracle installed

by: Paul | last post by:

Hi: I am totally new in Sun Solaris. I am not sure someone would like to tell me how to rellocate Sun Solaris disk space where oracle installed? I installed Oracle 8i in Sun Solaris and set Oracle main table space called TABLES in unix disk space /dpp/live01. From the following, it's quite easy to see that the disk space of /dpp/live01 is 97%.Therefore how can i move some disk space of SWAP to /dpp/live01 without losing

Oracle Database

8407

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8319

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8512

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7347

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6175

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5638

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4171

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2739

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1969

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP