| X server problem & creating a second database on HP-UX [message #132648] |
Mon, 15 August 2005 08:53  |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Hi everyone,
I am a beginner Oracle DBA with very little experience on UNIX systems
1. I have an HP-UX server on which the database resides. I connected to it through my windows machine and tried to open dbca(database configuration assistant). But it gives me the following error message:
Exception in thread "main" java.lang.internalerror: Can't connect to X11 window server using 0.0 as the value of the DISPLAY.
I dont have an X-server running on my windows machine. Should I first install the X-server and set the DISPLAY variable to <ip addres>:0.0.(The DISPLAY variable has to be set in the .profile file of the $HOME directory of the Oracle user....right?)
What does the command "xhost +" do? PLease suggest the solution.
2. I have an oracle database already created on a hp-ux server. The .profile file in the $HOME directory(of the oracle user) contains the entry oracle_sid=<sid_name>.
Now, if I have to create another database on the same server, what modifications should be made and are there any special settings to be made on the server?
Please help me. It's very very urgentttttttt.
Thanks in advance,
Sankalpa
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #132683 is a reply to message #132682] |
Mon, 15 August 2005 12:03  |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Hi Mahesh,
You mean that I have to overwrite the oracle_sid value from the old one to the new one before creating the new database.
Earlier,the value was oracle_sid=db_old. Now, I need to change it to oracle_sid=db_new in .profile file. Right? And the when I connect to either of the database instance(db_old,db_new) on the server, the oracle_sid value does not matter, right?
On another issue, when we do a full import of the database, do we have to create the tablespaces or do they get created automatically? On the other hand, if we are performing a user-mode import, we have to create the tablespaces as well as the users in the target database..right?
Thanks,
Sankalpa
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #132818 is a reply to message #132687] |
Tue, 16 August 2005 06:38 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Let me make myself clear. I have changed the oracle_sid varibale in .profile file to the new database to be created(new_db). When I connect(from my windows machine to the databases on the unix server) to the old datbase(old_db) using the command connect system/manager@old_db, or to the new database using connect system/manager@new_db, the oracle_sid value in the .profile file does not matter...right? Could you please explain the significance of .profile file and the oracle_sid variable in it?
Also, could you please suggest an X-window tool for download. I downloaded one from www.startnet.com. But since it is a demo version, the session ends and it gets disonnected after half hour which does not serve the purpose. Please suggest a reliable tool.
Thanks,
Sankalpa
|
|
|
|
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #132830 is a reply to message #132825] |
Tue, 16 August 2005 07:16 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Jus making sure. Assuming user1 is the user from which we are importing:
Create a tablespace(naming it anything) on the target database; create the user(say user2) and make the ts we jus created default to the user. Grant resource role to the user2.
Then run the command:
imp system/manager@targetdb fromuser=user1 touser=user2 ignore=y file=exp_user1.dmp log=imp_user2.log
Will this serve the purpose?
Btw I am downloading exceed2006 evaluation version from http://www.hummingbird.com
|
|
|
|
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #133235 is a reply to message #132846] |
Thu, 18 August 2005 03:21 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Hi Mahesh,
I have managed to create the database on the HP-UX server. I changed the oracle_sid(in the .profile file) to the new database and created the database through dbca(I installed exceed on my windows m/c and connected to the unix server).Also, I performed a user import to the new database. Now I have a strange problem. I connected to the database on the server from my windows client machine. Whenever I use the describe command on any table, it gives me ORA-03113: end-of-file on communication channel error. And, after this happens, it does not let me query any tables or views and it gives me the ORA-03114: not connected to ORACLE error. You can have a look at the SQL statements for the same given below:
C:\>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 17 12:31:00 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect user/user@db1
Connected.
SQL> select count(*) from table1;
COUNT(*)
----------
10
SQL> desc table1
ERROR:
ORA-03113: end-of-file on communication channel
SQL> select count(*) from table1;
select count(*) from table1
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
Could you please tell me what is going wrong here? I dont have any problem as such with my old database on the server. The problem is only with the new database that I just created. Please suggest me the solution.
Thanks & Regards,
Sankalpa
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #133631 is a reply to message #133529] |
Sat, 20 August 2005 06:26 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Following my question regarding the ORA-03113 and ORA-03114 errors, please find the following error message recorded in the alert_db1.log :
Errors in file /u01/oracle_home/OraHome1/rdbms/log/db1_ora_22805.trc:
ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []
The file db1_ora_22805.trc has the following contents towards its end:
KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
Please advise.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #133670 is a reply to message #133643] |
Sun, 21 August 2005 06:17 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
This was the output of the ipcs command for the semaphore settings:
# ipcs
IPC status from /dev/kmem as of Sun Aug 21 08:34:09 2005
T ID KEY MODE OWNER GROUP
Message Queues:
q 0 0x3c1c01ad -Rrw--w--w- root root
q 1 0x3e1c01ad --rw-r--r-- root root
Shared Memory:
m 8192 0x411c0140 --rw-rw-rw- root sys
m 8193 0x4e0c0002 --rw-rw-rw- root sys
m 8194 0x41201cc1 --rw-rw-rw- root sys
m 172035 0x5e100037 --rw------- root root
m 729092 0x0492b1cc --rw-rw---- oracle oinstall
m 8197 0x1575735c --rw-rw---- oracle oinstall
Semaphores:
s 0 0x4f1c027f --ra------- root root
s 4097 0x411c0140 --ra-ra-ra- root sys
s 4098 0x4e0c0002 --ra-ra-ra- root sys
s 4099 0x41201cc1 --ra-ra-ra- root sys
s 4 0x00446f6e --ra-r--r-- root root
s 5 0x00446f6d --ra-r--r-- root root
s 6 0x01090522 --ra-r--r-- root root
s 7 0x411c6eeb --ra-ra-ra- root root
s 8 0x6120149b --ra-ra-ra- root root
s 9 0x7320149b --ra-ra-ra- root root
s 10 0x7020149b --ra-ra-ra- root root
s 11 0x6920149b --ra-ra-ra- root root
s 12 0x7520149b --ra-ra-ra- root root
s 13 0x6320149b --ra-ra-ra- root root
s 14 0x6420149b --ra-ra-ra- root root
s 15 0x6620149b --ra-ra-ra- root root
s 16 0x6c20149b --ra-ra-ra- root root
s 17 0x6d20149b --ra-ra-ra- root root
s 18 0x6f20149b --ra-ra-ra- root root
s 19 0x410c0524 --ra-ra-ra- root root
s 20 0x00000001 --ra-ra-ra- root root
s 21 0x5220149b --ra-ra-ra- root root
s 12310 0x2d16f66c --ra-ra---- oracle oinstall
s 28695 0x0e6b9020 --ra-ra---- oracle oinstall
|
|
|
|
|
|
|
|
| Re: X server problem & creating a second database on HP-UX [message #133838 is a reply to message #133785] |
Mon, 22 August 2005 06:51 |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
That was an informative link sent by vadik77.
Just to be on the safe side, could someone please have a look at my kernel settings(I have two instances running on the system). The values in the brackets are calculated as per the installation documentation. Please advise if any of the values need to be changed
ksi_alloc_max 33600 (32768)
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit 4294967296 (2147483648)
maxssiz 134217728
maxssiz_64bit 1073741824
maxuprc 256 (((NPROC*9)/10) = 3686.4)
msgmap 1026 (msgtql+2=4098)
msgmni 4096
msgseg 16384 (32767)
msgtql 4096
ncsize 35328
nfile 63488
nflocks 4096
ninode 34816 (32976)
nkthread 8416 (7184)
nproc 4096
semmni 4096
semmns 16384 (semmni*2=8192)
semmnu 4092
semvmx 32767 (32768)
shmmax 3073741824
shmmni 400
shmseg 300
vps_ceiling 64
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
