If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > ORA-01034: Message 1034 not found;

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Junior Member
 
Join Date: Aug 2001
Posts: 4
Question ORA-01034: Message 1034 not found;

Hi All,

I am using oracle 8i release 2 on RHL 6.2. I had been able to successfully install and configure oracle, but then for some reasons I had to move my box to a new network. When I now try to start an instance of oracle, this is what I get:

svrmgrl > connect internal/password
ORA-01034: Message 1034 not found; No message file for product=RDBMS, facility=ORA

What could be wrong?

#echo ORACLE_HOME
/home/oracle/oracleinstall/app
#echo ORACLE_SID
usseipl

-- init.ora
db_name = "stcrm"
db_domain = softwareelements.com
instance_name = usseipl
service_names = stcrm.softwareelements.com
db_files = 1024 # LARGE
control_files = ("/home/oracle/oracleinstall/app/oradata/stcrm/control01.ctl", "
/home/oracle/oracleinstall/app/oradata/stcrm/control02.ctl", "/home/oracle/oracl
einstall/app/oradata/stcrm/control03.ctl")
open_cursors = 100
max_enabled_roles = 30
db_file_multiblock_read_count = 32 # LARGE

_use_ism = false
db_block_buffers = 2048 # INITIAL

shared_pool_size = 15728640 # INITIAL
large_pool_size = 614400
java_pool_size = 20971520

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 200 # INITIAL

log_buffer = 163840 # INITIAL

user_dump_dest = /home/oracle/oracleinstall/admin/stcrm/udump

db_block_size = 8192

remote_login_passwordfile = exclusive

os_authent_prefix = ""

compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536

-- listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/oracleinstall/app)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = stcrm.softwareelements.com)
(ORACLE_HOME = /home/oracle/oracleinstall/app)
(SID_NAME = usseipl)
)
)


-- tnsnames.ora
STCRM.SOFTWAREELEMENTS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stcrm.softwareelements.com)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)


Any help would be greatly appreciated. There are several documents that google fetches, but none of them really help!

Thanks.
manav.

ps: what does that "_use_ism = false" in init.ora mean?
__________________
Its impossible to watch a sunset, and not dream.
Reply With Quote
  #2 (permalink)  
Old
Junior Member
 
Join Date: Aug 2001
Posts: 4
Hi,

In continuation with this email:

1. tnsping <sid> (which in my case is usseipl) fails.
2. tnsping <service_name> (which in my case is stcrm.softwarelements.com) works.
3. orapwd file=orpw<sid> internal=<newpassword> gives an error: unable to find error file. The older pw file (and all files in this directory belong to oracleuser.oraclegroup).
4. sqlplus itself fails (:-) I know this is getting to be too much!). sqplus says:
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus

The files sp1us.msb and sp2us.msb exist under $ORACLE_HOME/sqlplus/mesg.

I still have no clues whats wrong?!!!

Should I go ahead and try creating a new database (with or without dbassist)?

Any pointers will be appreciated.

Manav.
__________________
Its impossible to watch a sunset, and not dream.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2003
Posts: 1
bad install

Answer of first post:
"_use_ism" should be "use_ism" from Harrison's Oracle Desk Reference (page 459) "if true this uses intimate data buffers, allowing SGAs of more than 4GB on supported platforms."

I reference to your missing *.msb files: when you installed on the new machine, did you get any errors? Recently I had similar issues, and a reinstall magically corrected the *.msb errors (most of the *.msb should be in $ORACLE_HOME/rdbms/mesg/)

I would also confirm that the $ORACLE_HOME and $ORACLE_BASE (not strictly necessary, but helpful) are set to correct paths.

Usually an OFA complient install will have ORACLE_HOME set to include something closer to $ORACLE_BASE/product/8.1.6/ as the finish of the path (replace 8.1.6 with the version of the db you are using).

In regards to the 1034 error, I am right now having similar odd issues- from an oracle shell account, I can log into the database. The listener is set up, and I can tnsping and trcroute correctly. If I try to log into a different OS user shell (ORACLE env variables set the same as the oracle OS user), I get a 1034 error. From the oracle user I can log into multiple oracle accounts from sqlplus.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2002
Location: California, USA
Posts: 482
Exclamation

Quote:
svrmgrl > connect internal/password
ORA-01034: Message 1034 not found; No message file for product=RDBMS, facility=ORA
You didn't setup the correct ORACLE_HOME, ORACLE_SID in your Linux shell. Do that and verify it - $ env

Most probably you have multiple Oracle homes, and the svrmgrl doesn't find the correct message files.

Couple of other things:

1. Since you have SOFTWAREELEMENTS.COM as TNS alias domain, check if the sqlnet.ora has SQLNET.DEFAULT_DOMAIN=SOFTWAREELEMENTS.COM too.

2. How come that in the listener.ora file you have - (SID_NAME = usseipl) , but in the tnsnames.ora is different - (SERVICE_NAME = stcrm.softwareelements.com) ? Which one is the right one ???


Hope that helps,

clio_usa
OCP - DBA
Visit our Web Site
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On